Postgres:Changing Data Directory - Revision history

Craigje at 17:41, 5 June 2019

2019-06-05T17:41:37Z

← Older revision		Revision as of 17:41, 5 June 2019
Line 1:		Line 1:
			Use this process to recover PostgreSQL data from the filesystem (i.e. when you can't just use a pg_dump from a functional instance).

	1. Shut down PostgreSQL (switch to postgres user)		1. Shut down PostgreSQL (switch to postgres user)
	:/usr/<postgres folder>/bin/pg_ctl stop -D /var/lib/pgsql/<version>/main/data		:/usr/<postgres folder>/bin/pg_ctl stop -D /var/lib/pgsql/<version>/main/data

Ktnguyen17 at 17:44, 24 May 2019

2019-05-24T17:44:19Z

← Older revision		Revision as of 17:44, 24 May 2019
Line 1:		Line 1:
	1. Shut down PostgreSQL		1. Shut down PostgreSQL (switch to postgres user)
	:/usr/<postgres folder>/bin/pg_ctl stop -D /var/lib/pgsql/<version>/main/data		:/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		::Example: /usr/pgsql-9.1/bin/pg_ctl stop -D /var/lib/pgsql/9.1/main/data
Line 9:		Line 9:
	4. Change ownership of the new directory and subdirectories to make sure postgres user has access to those		4. Change ownership of the new directory and subdirectories to make sure postgres user has access to those
	:sudo chown -R <ownername>:<groupname> <foldername>		:sudo chown -R <ownername>:<groupname> <foldername>
	5. Restart PostgreSQL		5. Restart PostgreSQL (switch to postgres user)
	:/usr/<postgres folder>/bin/pg_ctl start -D new/path/to/data		:/usr/<postgres folder>/bin/pg_ctl start -D new/path/to/data
	:/usr/<postgres folder>/bin/pg_ctl status -D new/path/to/data		:/usr/<postgres folder>/bin/pg_ctl status -D new/path/to/data

Ktnguyen17 at 17:31, 24 May 2019

2019-05-24T17:31:22Z

← Older revision		Revision as of 17:31, 24 May 2019
Line 3:		Line 3:
	::Example: /usr/pgsql-9.1/bin/pg_ctl stop -D /var/lib/pgsql/9.1/main/data		::Example: /usr/pgsql-9.1/bin/pg_ctl stop -D /var/lib/pgsql/9.1/main/data
	2. Make sure that PostgreSQL has been shut down successfully		2. Make sure that PostgreSQL has been shut down successfully
	:/usr/<postgres folder>/bin/pg_ctl status -D /var/lib/~~postgresql~~/<version>/main/data		:/usr/<postgres folder>/bin/pg_ctl status -D /var/lib/pgsql/<version>/main/data
	3. Find the PostgreSQL config file and edit it (usually in /etc/postgresql, but it might be in /var)		3. 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		:nano /etc/postgresql/<version>/main/postgresql.conf

Ktnguyen17 at 17:29, 24 May 2019

2019-05-24T17:29:51Z

← Older revision		Revision as of 17:29, 24 May 2019
Line 1:		Line 1:
	1. Shut down PostgreSQL		1. Shut down PostgreSQL
	:/usr/<postgres folder>/bin/pg_ctl stop -D /var/lib/pgsql/<version>/main/data		:/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		::Example: /usr/pgsql-9.1/bin/pg_ctl stop -D /var/lib/pgsql/9.1/main/data
	2. Make sure that PostgreSQL has been shut down successfully		2. Make sure that PostgreSQL has been shut down successfully
	:/usr/<postgres folder>/bin/pg_ctl status -D /var/lib/postgresql/<version>/main/data		:/usr/<postgres folder>/bin/pg_ctl status -D /var/lib/postgresql/<version>/main/data
Line 10:		Line 10:
	:sudo chown -R <ownername>:<groupname> <foldername>		:sudo chown -R <ownername>:<groupname> <foldername>
	5. Restart PostgreSQL		5. Restart PostgreSQL
	:/usr/<postgres folder>/bin/pg_ctl start -D <new path>		:/usr/<postgres folder>/bin/pg_ctl start -D new/path/to/data
	:/usr/<postgres folder>/bin/pg_ctl status -D <new path>		:/usr/<postgres folder>/bin/pg_ctl status -D new/path/to/data

Ktnguyen17: Created page with "1. Shut down PostgreSQL :/usr//bin/pg_ctl stop -D /var/lib/pgsql//main/data ::Example: /usr/pgsql-9.1/bin/pg_ctl stop -D var/lib/pgsql/9.1/main/data..."

2019-05-24T15:10:38Z

Created page with "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..."

New page

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
2. Make sure that PostgreSQL has been shut down successfully
:/usr/<postgres folder>/bin/pg_ctl status -D /var/lib/postgresql/<version>/main/data
3. 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
4. Change ownership of the new directory and subdirectories to make sure postgres user has access to those
:sudo chown -R <ownername>:<groupname> <foldername>
5. Restart PostgreSQL
:/usr/<postgres folder>/bin/pg_ctl start -D <new path>
:/usr/<postgres folder>/bin/pg_ctl status -D <new path>