pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Best practices for building and running on FreeBSD?
3+ messages / 2 participants
[nested] [flat]

* Best practices for building and running on FreeBSD?
@ 2007-02-07 00:15  Andrew Hammond <andrew.george.hammond@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Andrew Hammond @ 2007-02-07 00:15 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Best practices for building and running on FreeBSD?
@ 2007-02-07 14:31  Achilleas Mantzios <achill@matrix.gatewaynet.com>
  parent: Andrew Hammond <andrew.george.hammond@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Achilleas Mantzios @ 2007-02-07 14:31 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Andrew Hammond <andrew.george.hammond@gmail.com>

Στις Τετάρτη 07 Φεβρουάριος 2007 02:15, ο/η Andrew Hammond έγραψε:
> 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.

>
> 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

-- 
Achilleas Mantzios



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Best practices for building and running on FreeBSD?
@ 2007-02-07 15:20  Achilleas Mantzios <achill@matrix.gatewaynet.com>
  parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Achilleas Mantzios @ 2007-02-07 15:20 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Andrew Hammond <andrew.george.hammond@gmail.com>

Στις Τετάρτη 07 Φεβρουάριος 2007 16:31, ο/η Achilleas Mantzios έγραψε:
> Στις Τετάρτη 07 Φεβρουάριος 2007 02:15, ο/η Andrew Hammond έγραψε:
> > 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=freebsd%3Achangelog&cache=cache&media=freebsd:j...
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

-- 
Achilleas Mantzios



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-02-07 15:20 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-07 00:15 Best practices for building and running on FreeBSD? Andrew Hammond <andrew.george.hammond@gmail.com>
2007-02-07 14:31 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2007-02-07 15:20   ` Achilleas Mantzios <achill@matrix.gatewaynet.com>

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