Re: Move postmater.pid completly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Move postmater.pid completly
Дата
Msg-id 28495.1213806613@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Move postmater.pid completly  (wolfgang.graf@ksb.com)
Список pgsql-admin
wolfgang.graf@ksb.com writes:
> is there a way to move the postmaster.pid file
> completely out of the PGDATA directory ?

No, and it's unlikely to be seriously considered, because of the
enormously increased risk of starting two postmasters in the
same directory.  All it would take is for them to have different
ideas of where the lock file is.

> Background: we would like to start a postmaster instance on a readonly
> directory to enable a server for readonly operations (SELECT) only.

That won't ever work; the pid file is just the tip of the iceberg.

            regards, tom lane

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

Предыдущее
От: wolfgang.graf@ksb.com
Дата:
Сообщение: Move postmater.pid completly
Следующее
От: "pradeep kumar"
Дата:
Сообщение: URGENT: how to GRANT privillages to user/role on relation's row??