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

BUG #3758: Postmaster Service

From: "Sudarshan V Tantry" <sudarshantantry(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3758: Postmaster Service
Date: 2007-11-19 10:07:24
Message-ID: 200711191007.lAJA7OKt020767@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3758
Logged by:          Sudarshan V Tantry
Email address:      sudarshantantry(at)gmail(dot)com
PostgreSQL version: 7.8.2
Operating system:   Redhat Linux 3
Description:        Postmaster Service
Details: 

We are supporting a messaging system in which there are  two application
servers with cluster services.Cluster service does the job of shifting the
Application and Database services from one server to another if one of the
Application servers goes down.

Now,the problem is when we were testing the automatic shift over of
services,by manually stopping cluster service on one server using the
command "service clumanager stop" the Application and Database services get
shifted to another server,but Application services would be down due to the
fact that it cannot connect to the Database services since the postmaster
service is down.We check the status of Postmaster service with the command
"pg_ctl status".Even if we start the Postmaster service manually it goes
down whenever we stop the cluster service to shift the services back to the
first server. 
Also postmaster services do not start even when the server is restarted.
We checked the postgresql.log in which we could find this:
Unable to connect to database
      Cannotfind /var/lib/pgsql/DBDATA/data/postmaster.pid

DBDATA is the database service that is mounted on the application
server.That is getting mounted but postmaster would be found stopped.

Please let me a solution for this problem and also tell me why this problem
occurs.

Responses

pgsql-bugs by date

Next:From: Malcus ImhofDate: 2007-11-19 13:43:38
Subject: BUG #3760: Comment on restore database
Previous:From: Tom LaneDate: 2007-11-19 01:38:03
Subject: Re: 8.3b2: problem using "COPY ... TO/FROM .... BINARY"

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