>
> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
