Postgresql fail as boot time

Lists: pgsql-novice
From: "gibboda" <gibboda(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Postgresql fail as boot time
Date: 2006-06-02 13:22:44
Message-ID: 1149254564.032947.126510@g10g2000cwb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

I have a Fedora 5 System with Postgresql 8.1.4 installed. Manully
starting postgresql is fine but I get an error message with I try to
setup postgresql to start at boot time.

I am using the linux script under the contrib/start-scripts when I
downloaded and built postgresql.
manually executing this script works, but it fails at boot with the
logs stating this:

LOG: database system is ready
LOG: transaction ID wrap limit is 2147484146, limited by database
"postgres"
FATAL: lock file "postmaster.pid" already exists
HINT: Is another postmaster (PID 2561) running in data directory
"/usr/local/pgsql/data"?
LOG: received smart shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2006-06-02 08:36:50 EDT

I can not determine why this message is occuring.


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "gibboda" <gibboda(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgresql fail as boot time
Date: 2006-06-04 01:59:16
Message-ID: 25845.1149386356@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-novice

"gibboda" <gibboda(at)gmail(dot)com> writes:
> I have a Fedora 5 System with Postgresql 8.1.4 installed. Manully
> starting postgresql is fine but I get an error message with I try to
> setup postgresql to start at boot time.

> I am using the linux script under the contrib/start-scripts when I
> downloaded and built postgresql.

The stuff in contrib/start-scripts is pretty old and I wouldn't assume
it will work under hot-off-the-presses Linux versions. If I were you
I'd use the start script included in the RPM release.

Fedora 5 ships with Postgres 8.1 RPMs, so I dunno why you bothered
building your own copy at all ;-)

regards, tom lane