Re: Problem: Postgresql not starting - Mailing list pgsql-sql

From Christoph Haller
Subject Re: Problem: Postgresql not starting
Date
Msg-id 200311271005.LAA22427@rodos
Whole thread Raw
In response to Problem: Postgresql not starting  (mohan@physics.gmu.edu)
List pgsql-sql
> 
> Hi All
> I am using postgresql 7.2 on Linux. It does not start when i am trying th=
> is
> /etc/rc.d/init.d/postgresql restart.
> It give an error saying "postmaster already running".
> I have done
> rm -f /var/lib/pgsql/data/postmaster.pid
> and
> rm -f /var/run/postmaster.pid
> 
> But it still says the same. whenever i restart with the above command
> When say "stop" it says failed and when i say "start" it says postmaster
> already running.
> Please help me out
> 
> --m
> 
I've seen the other replies, but IMHO you are not supposed to remove 
/var/lib/pgsql/data/postmaster.pid 
to stop the postmaster but 

kill $(head -n 1 $PGDATA/postmaster.pid)

RTFM 
HTH 

Regards, Christoph 



pgsql-sql by date:

Previous
From: Andreas Tille
Date:
Subject: Re: Scaler forms as function arguments
Next
From: "Alexander M. Pravking"
Date:
Subject: Validity check in to_date?