(Best Practice) Moving the DS-System PostgreSQL database to a different drive

Issue

Moving DS-System PostgreSQL database to a different drive

Summary

Follow the steps below to move the DS-System Postgres database to a different drive:

1. Stop the DS-System & PostgreSQL services.

2. Make note of the PostgreSQL data folder's group, owner, and permissions (data folder usually located in /var/lib/pgsql/ directory).

3. Move the PostgreSQL data folder to new location.

4. Edit the Postgres startup script file (/etc/rc.d/init.d/Postgresql or /etc/ini.d/postgresql...) and change the PGDATA variable and all entries of the existing path to the new path.

Example, PGDATA=/var/lib/pgsql/9.2/data

5. Apply the same group, owner, and permissions to the PostgreSQL data folder (and sub folders) as they were before the move.

6. Start the PostgreSQL service. If the service failed to start please review the pgstartup.log file (usually located in the /var/lib/pgsql/ directory).

7. Once the PostgreSQL service is running start the DS-System service and ensure connectivity.