RDBMS Information - CAST Storage Service - How to move the CSS datafiles when getting messages - No Space left on device - CACHE FLUSHDATA

This page assists with step on how to move the CSS data files to a new file system when faced with messages like this:

ERROR: could not extend file "base/12401/557501": No space left on device

HINT: Check free disk space.

This message can be in the analysis log, but will also be in the postgres log. For finding the logs, please see this page: CAST Management Studio - Information - How to find logs

The analysis log message may be not as clear showing the problem with no space left on the device and may show something like this:

Procedure call failed: ?<kb_name>.CACHE_FLUSHDATA,I_IDSESSION

but still will show the space error in the postgres log.

For more information on CSS, refer to:

• Official documentation for CSS: CAST Storage Service
  

To move the CSS datafiles, do the following (for any details on starting and stopping CSS, see CAST Storage Service )

1. Stop CSS
2. Unregister the service with the following command from a command prompt (change the name to CastStorageService2 if you are doing this for CSS2)
   1. <CSS installation directory>\bin\pg_ctl.exe unregister -N CastStorageService3
3. Move the directory with all sub-directories to the new location.
   1. For example move all directories and sub-directories from the default location “C:\Program Files\Cast\CASTStorageService3\db_data” to the new location "S:\CASTStorageService3\db_data"
4. Register the service with the new location with the following command from a command prompt (change the name to CastStorageService2 if you are doing this for CSS2, and modify for the specific new location where the directories were moved):
   1. <CSS installation directory>\bin\pg_ctl.exe register -N CastStorageService3 -D "S:\CASTStorageService3\db_data"
      
5. Start CSS

 Ticket # 17260