Thread: 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.
Is 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+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. > > > ---------------------------(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 >-----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+daemontools > > >Is 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+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. >> >> >> ---------------------------(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 >> >
Is the data related to each other? How did you find open port numbers? Murthy Kambhampaty wrote: > 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+daemontools >> >> >>Is 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+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. >>> >>> >>>---------------------------(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: > 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+daemontools >> >> >>Is 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+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. >>> >>> >>>---------------------------(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