=CE=A3=CF=84=CE=B9=CF=82 Thursday 17 January 2008 07:52:50 =CE=BF/=CE=B7
Ma=
rc G. Fournier =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> mischa_sandberg@[EMAIL PROTECTED]
(Mischa Sandberg) writes:
>=20
> >Unfortunately, with multiple jails running PG servers and (due to app
> >limitations) all servers having same PG****T, 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
>=20
> Easiest fix: change the UID of the user running the postmaster (ie.
pgsql=
) so=20
> that each runs as a distinct UID (instead of distinct PG****T) ... been
do=
ing=20
> 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=3Dfre=
ebsd: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,
PG=
****T in all pgsql
server instances.
Do you know if any of this stuff make it anywhere in official FreeBSD?
--=20
Achilleas Mantzios
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@[EMAIL PROTECTED]
so that your
message can get through to the mailing list cleanly


|