Re: [ADMIN] postgresql in FreeBSD jails: proposal - Mailing list pgsql-hackers

From Mischa Sandberg
Subject Re: [ADMIN] postgresql in FreeBSD jails: proposal
Date
Msg-id 1200613953.478fea419c929@webmail.telus.net
Whole thread Raw
In response to Re: [ADMIN] postgresql in FreeBSD jails: proposal  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Quoting Tom Lane <tgl@sss.pgh.pa.us>:

> Mischa Sandberg <mischa_sandberg@telus.net> writes:
> > I'm going to skip the kill(1,0) test and depend on nattch only,
> > with a function that PGSharedMemoryIsInUse() can also use.
> > (For a healthy server, nattch is never less than 2, right?)
> 
> Oh, forgot to mention: healthy servers are not the point here.
> You should make the code keep its hands off any segment with
> nonzero nattch, because even one orphaned backend is enough
> to cause trouble.

Note taken. Worth putting a warning in the log, too?

Engineers think that equations approximate reality.
Physicists think that reality approximates the equations.
Mathematicians never make the connection.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal
Next
From: Tom Lane
Date:
Subject: Re: Simple thing to make pg_autovacuum more useful