From: Andrew Hammond <andrew.george.hammond@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Best practices for building and running on FreeBSD?
Date: 6 Feb 2007 16:15:44 -0800
Message-ID: <1170807344.283426.96030@a75g2000cwd.googlegroups.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: andrew.george.hammond@gmail.com
Subject: Re: Best practices for building and running on FreeBSD?
In-Reply-To: <1170807344.283426.96030@a75g2000cwd.googlegroups.com>
References: <1170807344.283426.96030@a75g2000cwd.googlegroups.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox