How can I change the Postgres data_directory folder location?

Question

I use Ubuntu 12.04, postgresql 9,1 postgis 1.5. I want to change database location. I use instruction http://www.whiteboardcoder.com/2012/04/change-postgres-datadirectory-folder.html The only difference is that I do not use postgres account for changing file /etc/postgresql/9.1/main/postgresql.conf

When I resatrt postgresql i have error:

Error: pid file is invalid

How can I change the database location?

Have you tried "manually kill the stale server process" like suggested in the 2nd link you gave? — , Nov 23 '13 at 11:51

score 1 · Accepted Answer · answered Nov 23 '13 at 11:28

1

Use the appropriate tools - pg_createcluster in this case. Take a closer look at its --datadir= option.

answered Nov 23 '13 at 11:28

Milen A. Radev

1 Answers1