postgres+daemontools
I'm about to install postgres on a box that has daemontools on it
and I would like to use it. Is there anybody here already running postgres
from daemontools? Is it advisable? Do you have any problems or issues I
should took care before trying it?
Thanks in advance.
We recently started using daemontools to manage the herd of postmasters (see
the recent thread regarding running multiple postmasters on a single
machine), and its working quite well.
We still have to figure out how to mimic the
"pg_ctl stop -m fast|immediate" modes,
svc -d /service/<server name> mimics "pg_ctl stop -m smart" which may be all
we need (I guess svc -i /service/<server name>; svc -d /service/<server
name>" effectively gives the "fast" mode.)
Murthy
-----Original Message-----
From: Kolus Maximiliano [mailto:Kolus.maximiliano@bcr.com.ar]
Sent: Wednesday, August 06, 2003 10:28
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres+daemontools
I'm about to install postgres on a box that has daemontools on it and I
would like to use it. Is there anybody here already running postgres from
daemontools? Is it advisable? Do you have any problems or issues I should
took care before trying it?
Thanks in advance.
Import Notes
Resolved by subject fallback
Is this multiple postmasters agains the SAME database? Or against multiple copies?
Murthy Kambhampaty wrote:
Show quoted text
We recently started using daemontools to manage the herd of postmasters (see
the recent thread regarding running multiple postmasters on a single
machine), and its working quite well.We still have to figure out how to mimic the
"pg_ctl stop -m fast|immediate" modes,
svc -d /service/<server name> mimics "pg_ctl stop -m smart" which may be all
we need (I guess svc -i /service/<server name>; svc -d /service/<server
name>" effectively gives the "fast" mode.)Murthy
-----Original Message-----
From: Kolus Maximiliano [mailto:Kolus.maximiliano@bcr.com.ar]
Sent: Wednesday, August 06, 2003 10:28
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres+daemontoolsI'm about to install postgres on a box that has daemontools on it and I
would like to use it. Is there anybody here already running postgres from
daemontools? Is it advisable? Do you have any problems or issues I should
took care before trying it?
Thanks in advance.---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
It's multiple postmaster's, each with its own $PGDATA folder and TCP port.
See:
http://marc.theaimsgroup.com/?l=postgresql-admin&w=2&r=1&s=Run+4+postgresql+
session+on+ONE+server%3F&q=b
Show quoted text
-----Original Message-----
From: Dennis Gearon [mailto:gearond@cvc.net]
Sent: Wednesday, August 06, 2003 11:59
To: Murthy Kambhampaty
Cc: 'Kolus Maximiliano'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres+daemontoolsIs this multiple postmasters agains the SAME database? Or
against multiple copies?Murthy Kambhampaty wrote:
We recently started using daemontools to manage the herd of
postmasters (see
the recent thread regarding running multiple postmasters on a single
machine), and its working quite well.We still have to figure out how to mimic the
"pg_ctl stop -m fast|immediate" modes,
svc -d /service/<server name> mimics "pg_ctl stop -m smart"which may be all
we need (I guess svc -i /service/<server name>; svc -d
/service/<server
name>" effectively gives the "fast" mode.)
Murthy
-----Original Message-----
From: Kolus Maximiliano [mailto:Kolus.maximiliano@bcr.com.ar]
Sent: Wednesday, August 06, 2003 10:28
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres+daemontoolsI'm about to install postgres on a box that has daemontools
on it and I
would like to use it. Is there anybody here already running
postgres from
daemontools? Is it advisable? Do you have any problems or
issues I should
took care before trying it?
Thanks in advance.---------------------------(end of
broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an
index scan if your
joining column's datatypes do not match
Import Notes
Resolved by subject fallback
Is the data related to each other? How did you find open port numbers?
Murthy Kambhampaty wrote:
Show quoted text
It's multiple postmaster's, each with its own $PGDATA folder and TCP port.
See:
http://marc.theaimsgroup.com/?l=postgresql-admin&w=2&r=1&s=Run+4+postgresql+
session+on+ONE+server%3F&q=b-----Original Message-----
From: Dennis Gearon [mailto:gearond@cvc.net]
Sent: Wednesday, August 06, 2003 11:59
To: Murthy Kambhampaty
Cc: 'Kolus Maximiliano'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres+daemontoolsIs this multiple postmasters agains the SAME database? Or
against multiple copies?Murthy Kambhampaty wrote:
We recently started using daemontools to manage the herd of
postmasters (see
the recent thread regarding running multiple postmasters on a single
machine), and its working quite well.We still have to figure out how to mimic the
"pg_ctl stop -m fast|immediate" modes,
svc -d /service/<server name> mimics "pg_ctl stop -m smart"which may be all
we need (I guess svc -i /service/<server name>; svc -d
/service/<server
name>" effectively gives the "fast" mode.)
Murthy
-----Original Message-----
From: Kolus Maximiliano [mailto:Kolus.maximiliano@bcr.com.ar]
Sent: Wednesday, August 06, 2003 10:28
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres+daemontoolsI'm about to install postgres on a box that has daemontools
on it and I
would like to use it. Is there anybody here already running
postgres from
daemontools? Is it advisable? Do you have any problems or
issues I should
took care before trying it?
Thanks in advance.---------------------------(end of
broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an
index scan if your
joining column's datatypes do not match
I didn't see daemon tools mentioned anywhere in these.
Murthy Kambhampaty wrote:
Show quoted text
It's multiple postmaster's, each with its own $PGDATA folder and TCP port.
See:
http://marc.theaimsgroup.com/?l=postgresql-admin&w=2&r=1&s=Run+4+postgresql+
session+on+ONE+server%3F&q=b-----Original Message-----
From: Dennis Gearon [mailto:gearond@cvc.net]
Sent: Wednesday, August 06, 2003 11:59
To: Murthy Kambhampaty
Cc: 'Kolus Maximiliano'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres+daemontoolsIs this multiple postmasters agains the SAME database? Or
against multiple copies?Murthy Kambhampaty wrote:
We recently started using daemontools to manage the herd of
postmasters (see
the recent thread regarding running multiple postmasters on a single
machine), and its working quite well.We still have to figure out how to mimic the
"pg_ctl stop -m fast|immediate" modes,
svc -d /service/<server name> mimics "pg_ctl stop -m smart"which may be all
we need (I guess svc -i /service/<server name>; svc -d
/service/<server
name>" effectively gives the "fast" mode.)
Murthy
-----Original Message-----
From: Kolus Maximiliano [mailto:Kolus.maximiliano@bcr.com.ar]
Sent: Wednesday, August 06, 2003 10:28
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres+daemontoolsI'm about to install postgres on a box that has daemontools
on it and I
would like to use it. Is there anybody here already running
postgres from
daemontools? Is it advisable? Do you have any problems or
issues I should
took care before trying it?
Thanks in advance.---------------------------(end of
broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an
index scan if your
joining column's datatypes do not match
On Wed, Aug 06, 2003 at 11:28:23 -0300,
Kolus Maximiliano <Kolus.maximiliano@bcr.com.ar> wrote:
I'm about to install postgres on a box that has daemontools on it
and I would like to use it. Is there anybody here already running postgres
from daemontools? Is it advisable? Do you have any problems or issues I
should took care before trying it?
I find it much simpler to run multiple instances of postgres than using
RH's init script.
The run file I use is:
#!/bin/sh
exec 2>&1
exec setuidgid postgres /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data