Re: PostgreSQL lock file

Поиск
Список
Период
Сортировка
От Олег Самойлов
Тема Re: PostgreSQL lock file
Дата
Msg-id 9C1CF14F-DBB7-4AF1-A42D-28B4ADFF0556@ya.ru
обсуждение исходный текст
Ответ на Re: PostgreSQL lock file  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> Best practice for this sort of thing is considered to be to run the two
> Postgres instances under different user IDs.  That avoids them thinking
> that the other one's lock files are relevant, and it provides an extra
> layer of security against possible conflicts between the two instances.
>
>             regards, tom lane

Thanks, an interesting  notice. I already did changes in start script to check instance by pg_ctl status and delete
lockfile if status<>0. But your recommendation is looked better. 


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

Предыдущее
От: "James(王旭)"
Дата:
Сообщение: How to gracefully keep my specific index in memory ?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: How to gracefully keep my specific index in memory ?