From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: postgresql in FreeBSD jails: proposal |
Date: | 2008-01-17 08:21:33 |
Message-ID: | 200801171021.33707.achill@matrix.gatewaynet.com |
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 |
Στις Thursday 17 January 2008 07:52:50 ο/η Marc G. Fournier έγραψε:
> mischa_sandberg(at)telus(dot)net (Mischa Sandberg) writes:
>
> >Unfortunately, with multiple jails running PG servers and (due to app
> >limitations) all servers having same PGPORT, you get the situation that
> >when jail#2 (,jail#3,...) server comes up, it:
> >- detects that there is a shm seg with ipc key 5432001
> >- checks whether the associated postmaster process exists (with kill -0)
> >- overwrites the segment created and being used by jail #1
>
> Easiest fix: change the UID of the user running the postmaster (ie. pgsql) so
> that each runs as a distinct UID (instead of distinct PGPORT) ... been doing
> this since moving to FreeBSD 6.x ... no patches required ...
Hi Marc,
what happened with the patches at http://docs.freevps.com/doku.php?id=freebsd:changelog?
Those patches are supposed to make IPC run without collisions in many jails, thus solving the
classic problem with postgresql, allowing the admin to use the same uid, PGPORT in all pgsql
server instances.
Do you know if any of this stuff make it anywhere in official FreeBSD?
--
Achilleas Mantzios
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-01-17 13:48:14 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
Previous Message | Achilleas Mantzios | 2008-01-17 08:11:30 | Re: postgresql in FreeBSD jails: proposal |
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2008-01-17 09:01:19 | Re: Bug in all version with encryption |
Previous Message | Michael Akinde | 2008-01-17 08:17:43 | BUG #3881: lo_open leaks memory |
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2008-01-17 11:06:28 | pgsql: pgcrypto doc updates Marko Kreen |
Previous Message | Achilleas Mantzios | 2008-01-17 08:11:30 | Re: postgresql in FreeBSD jails: proposal |
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2008-01-17 09:40:00 | Re: query performance |
Previous Message | Achilleas Mantzios | 2008-01-17 08:11:30 | Re: postgresql in FreeBSD jails: proposal |
From | Date | Subject | |
---|---|---|---|
Next Message | Brendan Jurd | 2008-01-17 09:16:24 | Re: to_char incompatibility |
Previous Message | Achilleas Mantzios | 2008-01-17 08:11:30 | Re: postgresql in FreeBSD jails: proposal |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-01-17 13:48:14 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
Previous Message | Achilleas Mantzios | 2008-01-17 08:11:30 | Re: postgresql in FreeBSD jails: proposal |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-01-17 13:48:14 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
Previous Message | Achilleas Mantzios | 2008-01-17 08:11:30 | Re: postgresql in FreeBSD jails: proposal |
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Kreen | 2008-01-17 10:02:06 | minor pgcrypto doc update |
Previous Message | Achilleas Mantzios | 2008-01-17 08:11:30 | Re: postgresql in FreeBSD jails: proposal |