multiple postgresql servers in multiple jails?

Oliver Fromme olli at
Tue Oct 23 13:07:42 PDT 2007

Oliver Peter wrote:
 > Does anybody have a running system with more than one jail hosting
 > more than one postgres server?

Yes, you must configure them to use different port numbers,
because the SysV IPC IDs are derived from the port number.
If you try to run both servers with the default port, you'll
get a conflict.  Configure different port numbers, and it
will work.

By the way, the PostgreSQL developers do _not_ recommend to
run multiple servers on the same machine, because of bad
efficiency.  It is much better (performance-wise) to run
all databases within the same server engine.  PostgreSQL
has all the authentication and permission features you need
to separate multiple databases within a single server, so
there is really no need to use multiple jails.

 > options         SHMMAXPGS=65536
 > options         SEMMNI=40
 > options         SEMMNS=240
 > options         SEMUME=40
 > options         SEMMNU=120

I have these on a machine with a single PostgreSQL server,
as per recommendations of the developers:

options         SHMMAXPGS=65536
options         SEMMAP=1024
options         SEMMNI=64
options         SEMMNS=1024
options         SEMUME=64
options         SEMMNU=128

Best regards

Oliver Fromme, secnetix GmbH & Co. KG, Marktplatz 29, 85567 Grafing b. M.
Handelsregister: Registergericht Muenchen, HRA 74606,  Geschäftsfuehrung:
secnetix Verwaltungsgesellsch. mbH, Handelsregister: Registergericht Mün-
chen, HRB 125758,  Geschäftsführer: Maik Bachmann, Olaf Erb, Ralf Gebhart

FreeBSD-Dienstleistungen, -Produkte und mehr:

"C++ is the only current language making COBOL look good."
        -- Bertrand Meyer

More information about the freebsd-questions mailing list