From: | Sairam Krishnamurthy <kmsram420(at)gmail(dot)com> |
---|---|
To: | Scott Mead <scottm(at)openscg(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Moving the data directory |
Date: | 2011-02-15 21:58:10 |
Message-ID: | AANLkTikD-KGTmx45vxK+uaPgAXyJkUY+jspdgcR-dNgN@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
None. The log is empty.
Thanks,
Sairam Krishnamurthy
+1 612 859 8161
On Tue, Feb 15, 2011 at 3:45 PM, Scott Mead <scottm(at)openscg(dot)com> wrote:
>
> On Tue, Feb 15, 2011 at 4:41 PM, Sairam Krishnamurthy <kmsram420(at)gmail(dot)com>
> wrote:
>>
>> 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?
>
> Do you have any useful information in the logs?
>
> /var/log/postgresql/postgresql-8.4-main.log
>
> --Scott
>
>
>
>>
>> TIA
>>
>> Thanks,
>> Sairam Krishnamurthy
>> +1 612 859 8161
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jan-Peter Seifert | 2011-02-15 22:00:10 | Re: cp1250 problem |
Previous Message | Scott Mead | 2011-02-15 21:45:11 | Re: Moving the data directory |