Skip site navigation (1) Skip section navigation (2)

Re: Moving the data directory

From: Scott Mead <scottm(at)openscg(dot)com>
To: Sairam Krishnamurthy <kmsram420(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Moving the data directory
Date: 2011-02-15 22:48:46
Message-ID: AANLkTik1_0+dyrUhHq76i_Xm1TX5snNrT4W22cgStA+h@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Feb 15, 2011 5:44 PM, "Sairam Krishnamurthy" <kmsram420(at)gmail(dot)com> wrote:
>
> Again,
>
> pg_ctl: could not open PID file
"/media/extension/var/lib/postgresql/8.4/main/postmaster.pid": Permission
denied
>
> Tried all the different ownership possible.

What about the permissions on your mountpoint?  Are they too restrictive for
the postgres user?  ( or any of the higher level dirs)
>
> Thanks,
> Sairam Krishnamurthy
> +1 612 859 8161
>
>
> On 02/15/2011 04:37 PM, Scott Mead wrote:
>>
>>
>>
>> On Tue, Feb 15, 2011 at 5:32 PM, Sairam Krishnamurthy <
kmsram420(at)gmail(dot)com> wrote:
>>>
>>> Scott,
>>>
>>> I get this error.
>>>
>>> server starting
>>> krishnam(at)nipa-umh:/media/extension/var/lib$ postgres: invalid argument:
"config_file=/etc/postgresql/8.4/main/postgresql.conf"
>>>
>>> tried with both -o and -c arguments.
>>
>>
>> My mistake, I screwed up!
>>
>> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
/media/extension/var/lib/postgresql/8.4/main/ -o "-c
config_file="/etc/postgresql/8.4/main/postgresql.conf"
>>
>>  (-c inside the quotes)
>>
>> --Scott
>>
>>> Thanks,
>>> Sairam Krishnamurthy
>>> +1 612 859 8161
>>>
>>>
>>> On 02/15/2011 04:27 PM, Scott Mead wrote:
>>>>
>>>> /usr/lib/postgresql/8.4/bin/pg_ctl start -D
/media/extension/var/lib/postgresql/8.4/main/ -o
config_file="/etc/postgresql/8.4/main/postgresql.conf
>>
>>

In response to

Responses

pgsql-admin by date

Next:From: Sairam KrishnamurthyDate: 2011-02-15 22:54:10
Subject: Re: Moving the data directory
Previous:From: Sairam KrishnamurthyDate: 2011-02-15 22:43:56
Subject: Re: Moving the data directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group