Skip site navigation (1) Skip section navigation (2)

Init script for multiple postmasters

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 (view raw or flat)
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







Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2006-05-22 12:33:45
Subject: Re: Init script for multiple postmasters
Previous:From: Jeff FrostDate: 2006-05-21 21:39:06
Subject: Re: does wal archiving block the current client connection?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group