Re: [JDBC] postgresql in FreeBSD jails: proposal

Στις Thursday 17 January 2008 07:52:50 ο/η Marc G. Fournier έγραψε:
> mischa_sandberg@telus.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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly