Re: postmaster.pid file auto-clean up? - Mailing list pgsql-general

From Michael Clark
Subject Re: postmaster.pid file auto-clean up?
Date
Msg-id CACAT_Ad1U1AUvK75h-km0OkwKDzmmufRoOGCc0Q47myqXByO5g@mail.gmail.com
Whole thread Raw
In response to Re: postmaster.pid file auto-clean up?  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general


On Sun, Aug 26, 2012 at 1:25 PM, Alban Hertroys <haramrae@gmail.com> wrote:
> We back our client application with PG,

> each OSX user gets their own instance of PG.

Are you certain that's necessary?


It was a decision made, weighing various trade-offs, 4 years ago now.


> In the wild this scenario has arisen without intentional interference.  In debugging, yes, we contrived the situation to replicate the behaviour.  Mind you, we may be using PG in an environment that isn't advisable.

What you replicated is not what happens when your problem occurs. Processes don't do things like that with each others PID files.


That is true.
But the system does recycle pids, especially after a reboot.

I appreciate all the feedback and input from everyone who responded.
Thank you!!  You have answered our questions, and it gives us food for thought.


Michael.

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: postmaster.pid file auto-clean up?
Next
From: Wolfgang Keller
Date:
Subject: Re: Some thoughts on table inheritance (which is uniquely awesome on PostgreSQL)