Re: BUG #3748: Postmaster Service

A couple things:

On Thu, Nov 15, 2007 at 12:49:40PM +0000, Sudarshan V Tantry wrote:
> PostgreSQL version: 7.8.2

There is no PostgreSQL version numbered that.

> 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.

So you have two application servers and two database servers? Two servers
with the application and database on each? I don't really understand.
Also,

> 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

In what sense do they get shifted to another server, if the postmaster
doesn't start up?

> Also postmaster services do not start even when the server is restarted.

Is there a start up script for postgres?

>
> DBDATA is the database service that is mounted on the application
> server.

I don't understand this sentence either. But. . .

> That is getting mounted but postmaster would be found stopped.

. . .mounting a directory does not entail starting a database server. These
are separate problems. You have to have the PostgreSQL data area mounted,
and _then_ start PostgreSQL. Perhaps your cluster thingy isn't doing it in
the right order.

In any case,

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

this doesn't seem to be a bug with PostgreSQL at all. If anything, it has
something to do with this cluster thing you're using. That's in general a
dangerous thing to do, and requires plenty of care. See the high
availability parts of the manual to read general discussions of this, but
if you're having specific problems, I think you need to talk to the people
who make the cluster software.

A

--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke