Skip site navigation (1) Skip section navigation (2)

Re: postgresql in FreeBSD jails: proposal

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, "pgadmin-devteam(at)postgresql(dot)org(dot)pgadmin-hackers(at)postgresql(dot)org(dot)pgadmin-support(at)postgresql(dot)org(dot)pgsql-admin(at)postgresql(dot)org(dot)pgsql-advocacy(at)postgresql(dot)org(dot)pgsql-announce(at)postgresql(dot)org(dot)pgsql-benchmarks(at)postgresql(dot)org(dot)pgsql-bugs(at)postgresql(dot)org(dot)pgsql-chat"(at)pos
Subject: Re: postgresql in FreeBSD jails: proposal
Date: 2008-01-17 08:11:30
Message-ID: 200801171011.30904.achill@matrix.gatewaynet.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-bugspgsql-committerspgsql-generalpgsql-hackerspgsql-jdbcpgsql-odbcpgsql-patches
Στις Thursday 17 January 2008 07:52:50 ο/η Marc G. Fournier έγραψε:
> 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 ...

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

In response to

pgsql-odbc by date

Next:From: Achilleas MantziosDate: 2008-01-17 08:21:33
Subject: Re: postgresql in FreeBSD jails: proposal
Previous:From: Marc G. FournierDate: 2008-01-17 06:17:53
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal

pgsql-patches by date

Next:From: Achilleas MantziosDate: 2008-01-17 08:21:33
Subject: Re: postgresql in FreeBSD jails: proposal
Previous:From: Peter EisentrautDate: 2008-01-17 08:10:52
Subject: Re: [HACKERS] SSL over Unix-domain sockets

pgsql-admin by date

Next:From: Achilleas MantziosDate: 2008-01-17 08:21:33
Subject: Re: postgresql in FreeBSD jails: proposal
Previous:From: Marc G. FournierDate: 2008-01-17 06:17:53
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal

pgsql-bugs by date

Next:From: Michael AkindeDate: 2008-01-17 08:17:43
Subject: BUG #3881: lo_open leaks memory
Previous:From: Suresh Gupta VGDate: 2008-01-17 07:44:53
Subject: Bug in all version with encryption

pgsql-hackers by date

Next:From: Achilleas MantziosDate: 2008-01-17 08:21:33
Subject: Re: postgresql in FreeBSD jails: proposal
Previous:From: Peter EisentrautDate: 2008-01-17 08:10:52
Subject: Re: [HACKERS] SSL over Unix-domain sockets

pgsql-committers by date

Next:From: Achilleas MantziosDate: 2008-01-17 08:21:33
Subject: Re: postgresql in FreeBSD jails: proposal
Previous:From: Marc G. FournierDate: 2008-01-17 06:17:53
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal

pgsql-general by date

Next:From: Achilleas MantziosDate: 2008-01-17 08:21:33
Subject: Re: postgresql in FreeBSD jails: proposal
Previous:From: Marc G. FournierDate: 2008-01-17 06:17:53
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal

pgsql-jdbc by date

Next:From: Achilleas MantziosDate: 2008-01-17 08:21:33
Subject: Re: postgresql in FreeBSD jails: proposal
Previous:From: Marc G. FournierDate: 2008-01-17 06:17:53
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group