Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id EB8869FB2CC for ; Tue, 6 Feb 2007 20:45:38 -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 33828-01 for ; Tue, 6 Feb 2007 20:45:27 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 914A19FB2B9 for ; Tue, 6 Feb 2007 20:45:38 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l170jctk084050 for ; Tue, 6 Feb 2007 20:45:38 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l170Ft4g079674 for pgsql-admin@postgresql.org; Tue, 6 Feb 2007 20:15:55 -0400 (AST) (envelope-from news) From: "Andrew Hammond" X-Newsgroups: pgsql.admin Subject: Best practices for building and running on FreeBSD? Date: 6 Feb 2007 16:15:44 -0800 Organization: http://groups.google.com Lines: 31 Message-ID: <1170807344.283426.96030@a75g2000cwd.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.8.1) Gecko/20061010 Firefox/2.0,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: a75g2000cwd.googlegroups.com; posting-host=68.111.42.215; posting-account=cSUlcA0AAABWACaPjo2Z9C0GBLTio512 To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/93 X-Sequence-Number: 24558 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. 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