Re: PostgreSQL lock file - Mailing list pgsql-general

From Олег Самойлов
Subject Re: PostgreSQL lock file
Date
Msg-id 9C1CF14F-DBB7-4AF1-A42D-28B4ADFF0556@ya.ru
Whole thread Raw
In response to Re: PostgreSQL lock file  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "James(王旭)"
Date:
Subject: How to gracefully keep my specific index in memory ?
Next
From: Laurenz Albe
Date:
Subject: Re: How to gracefully keep my specific index in memory ?