Difference between revisions of "Changing Data Directory"

@@ Line 1: / Line 1: @@
-. Shut down PostgreSQL
-:/usr/<postgres folder>/bin/pg_ctl stop -D /var/lib/pgsql/<version>/main/data
-::Example: /usr/pgsql-9.1/bin/pg_ctl stop -D var/lib/pgsql/9.1/main/data
-. Make sure that PostgreSQL has been shut down successfully
-:/usr/<postgres folder>/bin/pg_ctl status -D /var/lib/postgresql/<version>/main/data
-. Find the PostgreSQL config file and edit it (usually in /etc/postgresql, but it might be in /var)
-:nano /etc/postgresql/<version>/main/postgresql.conf
-:change the data_directory, pg_hba, and pg_ident lines to the new paths
-. Change ownership of the new directory and subdirectories to make sure postgres user has access to those
-:sudo chown -R <ownername>:<groupname> <foldername>
-. Restart PostgreSQL
-:/usr/<postgres folder>/bin/pg_ctl start -D <new path>
-:/usr/<postgres folder>/bin/pg_ctl status -D <new path>

Latest revision as of 10:09, 24 May 2019