Re: Problem starting postmaster at startup

I already tried that hoping that it was the problem but alas there was no
.pid file. When I run the exact same command as root, it starts fine.

Patrick Bye
Programmer / Analyst
Westfair Foods Ltd.
pbye(at)westfair(dot)ca
(403) 291-6538

-----Original Message-----
From: scott.marlowe [mailto:scott(dot)marlowe(at)ihs(dot)com]
Sent: Wednesday, January 29, 2003 5:02 PM
To: Patrick Bye (WFF)
Cc: 'pgsql-general(at)postgresql(dot)org'
Subject: Re: [GENERAL] Problem starting postmaster at startup

Try to see if you've postmaster.pid in the $PGDATA directory.

My guess is that the postmaster didn't make it all the way to shutdown
once, and the system kill -9'd it as the last step for shutting down, so
the .pid file is still there.

Just delete it and your database should start right up.

On Wed, 29 Jan 2003, Patrick Bye (WFF) wrote:

> My postgresql database has been starting up automatically at boot time for
4
> weeks until this week. No messages in the logfile why it doesn't start.
I
> am running version 7.2.3 in SuSE Linux 7.0 (s390). I did the build of
> postgres on this system.
>
> I had this difficulty when I first installed. I tried using the startup
> script from the contrib directory without any luck. I put it in the
> /etc/rc.d directory and created a symbolic link to it in the rc.2
directory
> for starting. The script works fine if I run it but wouldn't at startup.
> So I created my own in the same directory.
>
> #! /bin/sh
> case $1 in
> start)
> su -c '/usr/local/pgsql/bin/pg_ctl start -l
> /usr/local/pgsql/data/logfile -D /usr/local/pgsql/data' postgres
> ;;
> stop)
> su -c '/usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data'
> postgres
> ;;
> esac
>
> exit 0
>
> This has been working fine for 4 weeks. Now, all I get at startup is the
> message "postmaster successfully started" but I cannot find postmaster
> running anywhere in the system. I know pg_ctl is executing because of the
> message but postmaster is not logging anything at all.
>
> I know a little about *nix but not anything about the startup process.
Any
> help would be appreciated.
>
> Patrick Bye
> Programmer / Analyst
> Westfair Foods Ltd.
> pbye(at)westfair(dot)ca
> (403) 291-6538
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>