BUG #5118: start-status-insert-fatal - Mailing list pgsql-bugs

From Gerhard Leykam
Subject BUG #5118: start-status-insert-fatal
Date
Msg-id 200910151336.n9FDaQL3084899@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5118: start-status-insert-fatal
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5118
Logged by:          Gerhard Leykam
Email address:      gel123@sealsystems.de
PostgreSQL version: 8.4.0
Operating system:   linux
Description:        start-status-insert-fatal
Details:

Hi!

I am using a start script to set up my PostgreSQL database: it runs initdb,
if not done yet, starts the instance with pg_ctl start and checks everything
is fine by pg_ctl status.

If there is another PostgreSQL database on the same machine listening to the
same port, postmaster comes up, pg_ctl status says everthings fine, but
postmaster falls down with appropriate message in postgres.log.

All SQL commands in my script after status check are running against the
other database!

How do you think about some sort of postmaster.up file next to
postmaster.pid, which is created just as really everything is up and OK?

Regards,
  Gerhard

pgsql-bugs by date:

Previous
From: "cf of"
Date:
Subject: BUG #5117: Table type Function Bug when column dropped
Next
From: "Kevin Grittner"
Date:
Subject: Re: issue with integer nullable column and value 0