Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id DC09C9FA37A for ; Wed, 7 Feb 2007 11:20:26 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 06689-06 for ; Wed, 7 Feb 2007 11:20:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id AB4969FA39B for ; Wed, 7 Feb 2007 11:20:20 -0400 (AST) Received: from host3.dynacom.ondsl.gr ([62.103.35.211] helo=ip216.internal.net) by matrix.gatewaynet.com with esmtp (Exim 4.62) (envelope-from ) id 1HEoao-0003Ao-6c; Wed, 07 Feb 2007 17:20:18 +0200 From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: Best practices for building and running on FreeBSD? Date: Wed, 7 Feb 2007 17:20:17 +0200 User-Agent: KMail/1.9.3 Cc: "Andrew Hammond" References: <1170807344.283426.96030@a75g2000cwd.googlegroups.com> <200702071631.42329.achill@matrix.gatewaynet.com> In-Reply-To: <200702071631.42329.achill@matrix.gatewaynet.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200702071720.17889.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/104 X-Sequence-Number: 24569 =CE=A3=CF=84=CE=B9=CF=82 =CE=A4=CE=B5=CF=84=CE=AC=CF=81=CF=84=CE=B7 07 =CE= =A6=CE=B5=CE=B2=CF=81=CE=BF=CF=85=CE=AC=CF=81=CE=B9=CE=BF=CF=82 2007 16:31,= =CE=BF/=CE=B7 Achilleas Mantzios =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5: > =CE=A3=CF=84=CE=B9=CF=82 =CE=A4=CE=B5=CF=84=CE=AC=CF=81=CF=84=CE=B7 07 = =CE=A6=CE=B5=CE=B2=CF=81=CE=BF=CF=85=CE=AC=CF=81=CE=B9=CE=BF=CF=82 2007 02:= 15, =CE=BF/=CE=B7 Andrew Hammond =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5: > > I'm looking for a document on best practices for building and > > operating PostgreSQL on FreeBSD (amd64). Does such a thing already > > exist? If not, I'm willing to put one together and maintain it. > > > > Things I care about: > > 1) I need to run multiple postmasters on the same server. I think that > > jails may provide a good way to virtualize this. I haven't seen any > > documentation on running PostgreSQL in FreeBSD jails except for a > > number of emails how it fails for FreeBSD 5.2. > > Just follow > http://archives.postgresql.org/pgsql-hackers/2006-04/msg00037.php on what > to expect from running postgresql inside FreeBSD jails. Also jail2 patch (which is a new implementation) http://docs.freevps.com/lib/exe/fetch.php?id=3Dfreebsd%3Achangelog&cache=3D= cache&media=3Dfreebsd:jail2-releng6.diff.14.gz is definately worth a try. > > > 2) Each of these postmasters may be running a different PostgreSQL > > binary (or PostgreSQL binaries with different additional modules like > > Slony1 included). The existing FreeBSD ports do not support having > > multiple versions of the PostgreSQL binaries installed. Again, there > > may be a work around for this using jails of which I am unaware. > > Currently I'm contemplating simply building binary tarballs. > > > > 3) My sysadmin wants me to do the Right Thing with regards to > > packaging. > > > > 4) I would strongly prefer to use DJB's services / multilog stuff to > > handle logging the operation of the database. > > > > 5) I would like to conform to community standards with regards to > > configure options to facilitate debugging or core dump analysis should > > it be necessary. > > > > Any guidance on this would be much appreciated. > > > > Andrew > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 5: don't forget to increase your free space map settings =2D-=20 Achilleas Mantzios