Submitted for someone to tell me what the heck is going on....
[root@harmony log]# /etc/rc.d/init.d/postgresql stop
Stopping postgresql service: [ OK ]
[root@harmony log]# /etc/rc.d/init.d/postgresql start
Checking postgresql installation: looks good!
Postmaster already running.
[root@harmony log]#
----- Original Message -----
From: "Lamar Owen" <lamar.owen@wgcr.org>
To: "Dana Hudes" <dhudes@hudes.org>
Cc: <pgsql-admin@postgreSQL.org>
Sent: Wednesday, January 05, 2000 1:49 PM
Subject: Re: [ADMIN] weird fatal error starting postmaster
> Dana Hudes wrote:
> > I'm of course on RedHat Linux. Specifically v6.0 .Dual processor PII, running SMP kernel 2.2.5-22smp
> > I do (in inittab)
> > /bin/su - postgres -c "/usr/bin/postmaster -D/var/db" >>/var/log/postgres.log 2>&1 </dev/null
>
> Does postmaster start successfully if simply started -- not from
> inittab? Also, on RedHat, the standard location of the database is
> /var/lib/pgsql, not /var/db -- this could get you into trouble later if
> you run into other problems. This location should only be changed if
> there is really GOOD reason to do so.
>
> Run, as root, '/etc/rc.d/init.d/postgresql start' -- it'll initdb in
> /var/lib/pgsql if there's no database there. Then, attempt to connect,
> and see what happens. Feel free to modify the
> /etc/rc.d/init.d/postgresql script for logging purposes.
>
> --
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11