From: | "Nicola Mauri" <Nicola(dot)Mauri(at)saga(dot)it> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Init script for multiple postmasters |
Date: | 2006-05-22 11:16:03 |
Message-ID: | OF834510B3.4C033594-ONC1257176.00379DD0-C1257176.003DE59E@saga.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I'm trying to set up two postmasters on a two-node redhat cluster.
Instance #1:
pg_data: /var/lib/pgsql/data
user: postgres
Instance #2:
pg_data: /var/lib/pgsql2/data2
user: postgres2
Since databases are managed by cluster manager I need two different
initscripts. Unfortunately the script provided in the rpm uses the
'status' function which does not make difference between two groups of
processes:
$ /etc/init.d/postgresql status
postmaster (pid 5320 5319 5318 5316 5314) is running...
$ /etc/init.d/postgresql2 status
postmaster (pid 5320 5319 5318 5316 5314) is running...
In this scenario the cluster manager cannot determine wether a single
instance is running or down.
I'm going to modify initscripts and use a differente approach to probe
postmasters status, but I'm not sure if this is good:
ps ax | grep postmaster | grep /var/lib/pgsql2/data2
ps ax | grep postmaster | grep /var/lib/pgsql/data
What would you suggest?
Thanks
Nicola
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2006-05-22 12:33:45 | Re: Init script for multiple postmasters |
Previous Message | Jeff Frost | 2006-05-21 21:39:06 | Re: does wal archiving block the current client connection? |