Knowledge Base

Tracing Linux PostgreSQL Data Path

Follow the steps below to change the PostgreSQL data path on Linux, move the database files to a different folder and host them in the new path.

NOTE: The additional disk must be mounted.

Use the code below to stop the service.

sudo systemctl stop postgresql

Use the code below to move the files.

sudo rsync -av /var/lib/postgresql /media/ekdisk/

Edit the settings file. The path will vary depending on your version.

For example: sudo nano /etc/postgresql/9.5/main/postgresql.conf

sudo nano /etc/postgresql/10/main/postgresql.conf
data_directory = '/media/ekdisk/postgresql/10/main'

sudo systemctl start postgresql

To check:

sudo -u postgre psql

SHOW data_directory;