BUG #5041: Changing data_directory problem

Started by Jonasover 16 years ago3 messagesbugs
Jump to latest
#1Jonas
jonasdonovan@hotmail.com

The following bug has been logged online:

Bug reference: 5041
Logged by: Jonas
Email address: jonasdonovan@hotmail.com
PostgreSQL version: 8.4
Operating system: Ubuntu 9.10
Description: Changing data_directory problem
Details:

After changing data_directory - in the same way as I did for postgres 8.3 -
postgres 8.4 gives me:

root@ip-10-224-94-129:/mnt/postgresql/8.4/main# sudo
/etc/init.d/postgresql-8.4 start
* Starting PostgreSQL 8.4 database server
Error: could not exec /usr/lib/postgresql/8.4/bin/pg_ctl
/usr/lib/postgresql/8.4/bin/pg_ctl start -D /mnt/postgresql/8.4
/main -l /var/log/postgresql/postgresql-8.4-main.log -s -o -c
config_file="/etc/postgresql/8.4/main/postgresql.conf" :

#2Andres Freund
andres@anarazel.de
In reply to: Jonas (#1)
Re: BUG #5041: Changing data_directory problem

On Sunday 06 September 2009 19:29:54 Jonas wrote:

The following bug has been logged online:

Bug reference: 5041
Logged by: Jonas
Email address: jonasdonovan@hotmail.com
PostgreSQL version: 8.4
Operating system: Ubuntu 9.10
Description: Changing data_directory problem
Details:

After changing data_directory - in the same way as I did for postgres 8.3 -
postgres 8.4 gives me:

How did you do it in 8.3?

Andres

#3Martin Pitt
mpitt@debian.org
In reply to: Jonas (#1)
Re: BUG #5041: Changing data_directory problem

Jonas [2009-09-06 17:29 +0000]:

After changing data_directory - in the same way as I did for postgres 8.3 -

The official way is to move the directory and set "data_directory" in
postgresql.conf. (Or create a new cluster with the -d/--datadir option).

Is that what you did?

Please give us the output of "pg_lsclusters".

Thanks, Martin

--
Martin Pitt | http://www.piware.de
Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)