From: Marc G. Fournier <scrappy@hub.org>
To: pgadmin-devteam@postgresql.org.pgadmin-hackers
Subject: Re: postgresql in FreeBSD jails: proposal
Date: Thu, 17 Jan 2008 05:52:50 +0000 (UTC)
Message-ID: <fmmqfh$buq$3@news.hub.org> (raw)
References: <1200501702.478e33c61b74e@webmail.telus.net>
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 ...
--
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . scrappy@hub.org MSN . scrappy@hub.org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scrappy@hub.org, pgadmin-devteam@postgresql.org.pgadmin-hackers
Subject: Re: postgresql in FreeBSD jails: proposal
In-Reply-To: <fmmqfh$buq$3@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox