PostgreSQL in FreeBSD jails

[Marc G. Fournier]

On Tue, 26 Apr 2005, Bill Moran wrote:

> Alexander Rusinov <boot at eurocom.od.ua> wrote:
>> Hi,
>>
>> I need to run a number of PostgreSQL servers in different FreeBSD jails.
>> I managed to run a first instance of PostgreSQL server in a jail, but
>> after I launch a new server in another jail the first one starts to
>> return an error messages like the following:
>>
>> semctl(1507328, 4, SETVAL, 0) failed: Invalid argument
>>
>> The problem in general is: only one instance of PostgreSQL server
>> processes clients' connections, all of the others return semctl errors.
>
> I had this exact same problem.  I never found a solution.  The cause
> appears to be that, since shared memory is not segregated between jails,
> the newly launched Postgres instances corrupt the shared memory of
> previously running Postgres instances.

I'm running 9 jails on a server right now, each with their own instance:

# ps aux | grep postmaster|grep -- -D
scrappy 20043  0.0  0.0 18856  504  ??  SsJ  Thu08PM   0:58.55 /usr/local/bin/postmaster -D /usr/local/pgsql/data -S (postgres)
pgsql   39126  0.0  0.0  7480  400  ??  SsJ  19Apr05   0:00.99 /usr/local/bin/postmaster -D /usr/local/pgsql/data (postgres)
pgsql   38868  0.0  0.0  8224  552  ??  SsJ  19Apr05   0:02.08 /usr/local/bin/postmaster -D /usr/local/pgsql/data (postgres)
pgsql   37375  0.0  0.0  7180  404  ??  SsJ  19Apr05   0:02.47 /usr/local/bin/postmaster -D /usr/local/pgsql/data (postgres)
scrappy 36865  0.0  0.0 16556  744  ??  SsJ  19Apr05   0:08.32 /usr/local/bin/postmaster -D /usr/local/pgsql/data -S (postgres)
scrappy 36675  0.0  0.0 258184 1000  ??  SsJ  19Apr05   7:29.85 /usr/local/bin/postmaster -D /usr/local/pgsql/data -S (postgres)
scrappy 36569  0.0  0.0 14552  596  ??  SsJ  19Apr05   0:12.27 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data -S (postgres)
scrappy 35961  0.0  0.0 16624  580  ??  SsJ  19Apr05  12:26.68 /usr/local/bin/postmaster -D /usr/local/pgsql/data -S (postgres)
scrappy 54328  0.0  0.0 258248 1596  ??  SJ    1:55PM   0:00.00 /usr/local/bin/postmaster -D /usr/local/pgsql/data -S (postgres)

and never noticed any issues ... but, this is with 4.11, not 5.x, so maybe 
something has changed?


Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy at hub.org           Yahoo!: yscrappy              ICQ: 7615664