thanks for the idea. It says there is another copy of pg running but I've rebooted the system
and the inittab entry is commented out.
root@harmony log]# /etc/rc.d/init.d/postgresql status
postmaster (pid 565) is running...
[root@harmony log]# ps -l -p 565
FLAGS UID PID PPID PRI NI SIZE RSS WCHAN STA TTY TIME COMMAND
No processes available.
[root@harmony log]#
bizarre. I have this with other processes. For example there are two setiathome processes running
(1 per cpu). I know they're there
[root@harmony log]# uptime
3:18pm up 1 day, 20:12, 2 users, load average: 2.00, 2.00, 2.00
[root@harmony log]#
But I can't see them
[root@harmony log]# ps ax|grep seti
3025 ? S 0:00 grep seti
Weird.
----- 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
