From: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org> |
---|---|
To: | 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)postg |
Subject: | Re: postgresql in FreeBSD jails: proposal |
Date: | 2008-01-17 05:52:50 |
Message-ID: | fmmqfh$buq$3@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-bugs pgsql-committers pgsql-general pgsql-hackers pgsql-jdbc pgsql-odbc pgsql-patches |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-17 06:09:00 | Re: Strange client encoding issue |
Previous Message | Benjamin Krajmalnik | 2008-01-17 05:16:50 | Re: Strange client encoding issue |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-17 06:12:54 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
Previous Message | Tom Lane | 2008-01-16 21:01:00 | Re: BUG #3879: OS X Start Script should not `cd /Users/postgres` |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-17 06:12:54 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
Previous Message | Andrew Dunstan | 2008-01-16 22:07:04 | pgsql: Document the fact that COPY always uses the client encoding. |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-17 06:12:54 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
Previous Message | Chris | 2008-01-17 03:30:12 | Re: template0(or template1) is a database? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-17 06:12:54 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
Previous Message | Bruce Momjian | 2008-01-17 02:58:11 | Re: [HACKERS] SSL over Unix-domain sockets |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-17 06:12:54 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
Previous Message | Tom Lane | 2008-01-16 20:51:16 | Re: postgresql in FreeBSD jails: proposal |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-17 06:09:00 | Re: Strange client encoding issue |
Previous Message | Benjamin Krajmalnik | 2008-01-17 05:16:50 | Re: Strange client encoding issue |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-17 06:12:54 | Re: [ADMIN] postgresql in FreeBSD jails: proposal |
Previous Message | Bruce Momjian | 2008-01-17 02:58:11 | Re: [HACKERS] SSL over Unix-domain sockets |