Re: [ADMIN] weird fatal error starting postmaster

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