| 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.
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |