Στις Thursday 17 January 2008 07:52:50 ο/η Marc G. Fournier έγραψε:
[EMAIL PROTECTED] (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 4: Have you searched our list archives?
http://archives.postgresql.org
