From: | Sairam Krishnamurthy <kmsram420(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Moving the data directory |
Date: | 2011-02-15 21:41:26 |
Message-ID: | AANLkTik0FbNw2RC=3dMMGruB+UsJrXkpDGhAynAYp6TL@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
All,
I am using Ubuntu 10.04 and Postgres 8.4, I have been trying to move
my data dir to another device for the past couple of days but ran into
a lot of problems.
I did the following:
1. Copy the contents of /var/lib/postgresql/8.4/main to my folder.
2. Changed the data_directory in postgresql.conf.
When I start postgres using /etc/init.d script I get the following error,
* 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
/media/extension/var/lib/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" :
I tried changing the ownership of the
/media/extension/var/lib/postgresql dir to <myusername>, postgres and
root. Now of them worked and I keep getting the same error message.
I found a lot of similar problems online but none had a solution.
Can someone help me with this?
TIA
Thanks,
Sairam Krishnamurthy
+1 612 859 8161
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Mead | 2011-02-15 21:45:11 | Re: Moving the data directory |
Previous Message | Fabricio | 2011-02-15 18:02:39 | Re: mapping libraries |