| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mischa Sandberg <mischa_sandberg(at)telus(dot)net> |
| 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:49:32 |
| Message-ID: | 17061.1200613772@sss.pgh.pa.us |
| 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 |
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.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mischa Sandberg | 2008-01-17 23:52:33 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| Previous Message | Tom Lane | 2008-01-17 23:10:16 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mischa Sandberg | 2008-01-17 23:52:33 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| Previous Message | Tom Lane | 2008-01-17 23:10:16 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mischa Sandberg | 2008-01-17 23:52:33 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| Previous Message | Alvaro Herrera | 2008-01-17 23:47:07 | pgsql: Backpatch my fix of rev 1.48 to avoid a division-by-zero error in |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mischa Sandberg | 2008-01-17 23:52:33 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| Previous Message | Tom Lane | 2008-01-17 23:38:50 | Re: Trouble with UTF-8 data |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mischa Sandberg | 2008-01-17 23:52:33 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| Previous Message | Tom Lane | 2008-01-17 23:46:52 | Re: modularity of PostgreSQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mischa Sandberg | 2008-01-17 23:52:33 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| Previous Message | Tom Lane | 2008-01-17 23:10:16 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mischa Sandberg | 2008-01-17 23:52:33 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| Previous Message | Tom Lane | 2008-01-17 23:10:16 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mischa Sandberg | 2008-01-17 23:52:33 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
| Previous Message | Tom Lane | 2008-01-17 23:10:16 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |