Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will learn how to migrate the current data directory to a different location in PostgreSQL.
We can follow the steps below.
We learn the current data directory as follows.
1 2 3 4 | postgres=# show data_directory; data_directory ------------------------------ /var/lib/pgsql/13/data |
The PostgreSQL service is shut down.
1 | $ sudo systemctl stop postgresql-13 |
We do the migration using rsync.
1 | $ rsync -av /var/lib/pgsql/13/data /pg_data |
In the postgresql.conf file, data_directory is specified as the newly created directory.
1 2 | $ vi /var/lib/pgsql/13/data/postgresql.conf data_directory = '/pg_data/data' |
After the processes are completed, we start the service.
1 2 | $ sudo systemctl start postgresql-13 $ sudo systemctl status postgresql-13 |
Connect to the database and check the data directory.
1 2 3 4 5 | $ psql postgres=# show data_directory; data_directory ------------------------------ /pg_data/data |
