Re: Moving the data directory

Поиск
Список
Период
Сортировка
От Scott Mead
Тема Re: Moving the data directory
Дата
Msg-id AANLkTik1_0+dyrUhHq76i_Xm1TX5snNrT4W22cgStA+h@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Moving the data directory  (Sairam Krishnamurthy <kmsram420@gmail.com>)
Ответы Re: Moving the data directory  (Sairam Krishnamurthy <kmsram420@gmail.com>)
Список pgsql-admin


On Feb 15, 2011 5:44 PM, "Sairam Krishnamurthy" <kmsram420@gmail.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@gmail.com> wrote:
>>>
>>> Scott,
>>>
>>> I get this error.
>>>
>>> server starting
>>> krishnam@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
>>
>>

В списке pgsql-admin по дате отправления:

Предыдущее
От: Sairam Krishnamurthy
Дата:
Сообщение: Re: Moving the data directory
Следующее
От: Sairam Krishnamurthy
Дата:
Сообщение: Re: Moving the data directory