Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: postgresql in FreeBSD jails: proposal
- From: "Marc G. Fournier" <scrappy(at)hub(dot)org>
- To: pgadmin-devteam(at)postgresql(dot)org(dot)pgadmin-hackers@postgresql(dot)org(dot)pgadmin-support(at)postgresql(dot)org(dot)pgsql-admin@postgresql(dot)org(dot)pgsql-advocacy(at)postgresql(dot)org(dot)pgsql-announce@postgresql(dot)org(dot)pgsql-benchmarks(at)postgresql(dot)org(dot)pgsql-bugs@postgresql(dot)org(dot)pgsql-chat(at)postg
- Subject: Re: postgresql in FreeBSD jails: proposal
- Date: Thu, 17 Jan 2008 05:52:50 +0000 (UTC)
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 ... -- ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy(at)hub(dot)org MSN . scrappy(at)hub(dot)org Yahoo . yscrappy Skype: hub.org ICQ . 7615664
- Follow-Ups:
- Re: postgresql in FreeBSD jails: proposal
- From: Achilleas Mantzios
- Re: postgresql in FreeBSD jails: proposal
- Prev by Date: Re: trying to connect to pg from within a local network
- Next by Date: Re: Patch for Statement.getGeneratedKeys()
- Previous by thread: trying to connect to pg from within a local network
- Next by thread: Re: postgresql in FreeBSD jails: proposal
- Indexes: