Date: Wed, 24 Oct 2007 15:55:36 +0200 From: Oliver Peter <hoschi@mouhaha.de> To: freebsd-questions@FreeBSD.ORG Cc: freebsd-jail@FreeBSD.ORG Subject: Re: multiple postgresql servers in multiple jails? Message-ID: <20071024135535.GC22904@nemesis.frida.mouhaha.de> In-Reply-To: <200710232006.l9NK67BO052981@lurza.secnetix.de> References: <20071023180719.GA22904@nemesis.frida.mouhaha.de> <200710232006.l9NK67BO052981@lurza.secnetix.de>
next in thread | previous in thread | raw e-mail | index | archive | help
--0vzXIDBeUiKkjNJl
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
On Tue, Oct 23, 2007 at 10:06:08PM +0200, Oliver Fromme wrote:
> Oliver Peter wrote:
> > Does anybody have a running system with more than one jail hosting
> > more than one postgres server?
>=20
> 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.
Thanks for that hint. After changing the port numbers for each
instance to a different one, it works - but only at first glance.
After making some test creates and inserts to all servers at the same
time I receive the 'out of memory' messages again...
Different UIDs, different ports, same error.
> 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.
Of course I understand that. But I would like to setup a test server
in a different jail beside my production jail/pgsql-server to be sure
not to crash my production server.
Performance does not matter (at this time in this specific case of
course!).
> I have these on a machine with a single PostgreSQL server,
> as per recommendations of the developers:
>=20
> options SHMMAXPGS=3D65536
> options SEMMAP=3D1024
> options SEMMNI=3D64
> options SEMMNS=3D1024
> options SEMUME=3D64
> options SEMMNU=3D128
Is this a good recommendation for a machine with only 1GB of RAM?
--=20
Oliver PETER, eMail: hoschi@mouhaha.de, ICQ# 113969174
"Worker bees can leave. Even drones can fly away.
The Queen is their slave."
--0vzXIDBeUiKkjNJl
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.3 (FreeBSD)
iEYEARECAAYFAkcfTtcACgkQ6LH/IUVtaI/aagCgnDHROiuJpkwyx9hBFytWeMdh
ufwAnA0ntKl7vg3L9igJDywBb1u+GiD6
=Q0IV
-----END PGP SIGNATURE-----
--0vzXIDBeUiKkjNJl--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20071024135535.GC22904>