multiple postgresql servers in multiple jails?
Oliver Fromme
olli at lurza.secnetix.de
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
--
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: http://www.secnetix.de/bsd
"C++ is the only current language making COBOL look good."
-- Bertrand Meyer
More information about the freebsd-questions
mailing list