Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 061A19FB24E for ; Wed, 7 Feb 2007 10:31:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 98228-02 for ; Wed, 7 Feb 2007 10:31:50 -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 14E119FA0C0 for ; Wed, 7 Feb 2007 10:31:49 -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 1HEnpm-00039Z-Ms; Wed, 07 Feb 2007 16:31:42 +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 16:31:41 +0200 User-Agent: KMail/1.9.3 Cc: "Andrew Hammond" References: <1170807344.283426.96030@a75g2000cwd.googlegroups.com> In-Reply-To: <1170807344.283426.96030@a75g2000cwd.googlegroups.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200702071631.42329.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/102 X-Sequence-Number: 24567 =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.p= hp on what to expect from running postgresql inside FreeBSD jails. > > 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