Re: Moving the data directory

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
>>
>>