Re: [ADMIN] postgresql in FreeBSD jails: proposal

From: Mischa Sandberg <mischa_sandberg(at)telus(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal
Date: 2008-01-17 23:52:33
Message-ID: 1200613953.478fea419c929@webmail.telus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs pgsql-committers pgsql-general pgsql-hackers pgsql-jdbc pgsql-odbc pgsql-patches

Quoting Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> Mischa Sandberg <mischa_sandberg(at)telus(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Kempter 2008-01-18 04:45:25 more blob questions
Previous Message Tom Lane 2008-01-17 23:49:32 Re: [ADMIN] postgresql in FreeBSD jails: proposal

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-01-18 01:19:53 Re: BUG #3883: Autovacuum deadlock with truncate?
Previous Message Tom Lane 2008-01-17 23:49:32 Re: [ADMIN] postgresql in FreeBSD jails: proposal

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2008-01-18 00:13:50 pgsql: Stamp release for 8.3RC2; configure will be stamped by packager.
Previous Message Tom Lane 2008-01-17 23:49:32 Re: [ADMIN] postgresql in FreeBSD jails: proposal

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-01-17 23:54:19 case dumbiness in return from functions
Previous Message Tom Lane 2008-01-17 23:49:32 Re: [ADMIN] postgresql in FreeBSD jails: proposal

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-01-17 23:57:43 Re: Simple thing to make pg_autovacuum more useful
Previous Message Tom Lane 2008-01-17 23:49:32 Re: [ADMIN] postgresql in FreeBSD jails: proposal

Browse pgsql-jdbc by date

  From Date Subject
Next Message M.Khaled 2008-01-18 07:53:10 Can not access the public schema
Previous Message Tom Lane 2008-01-17 23:49:32 Re: [ADMIN] postgresql in FreeBSD jails: proposal

Browse pgsql-odbc by date

  From Date Subject
Next Message luiz 2008-01-18 11:23:55 Time to new release ?
Previous Message Tom Lane 2008-01-17 23:49:32 Re: [ADMIN] postgresql in FreeBSD jails: proposal

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2008-01-18 00:47:26 Re: [HACKERS] SSL over Unix-domain sockets
Previous Message Tom Lane 2008-01-17 23:49:32 Re: [ADMIN] postgresql in FreeBSD jails: proposal