"Hussain Jawad-FXRM43" <[EMAIL PROTECTED]> writes: > When I am trying to stop and start the DB, below error is reported in > postgresql start up log file.
Exactly what are you doing to start and stop the server? If you are using a startup script, whose is it? > I have deleted the file postmaster.pid in the directory > /var/lib/pgsql/data for number of times and restarted the postgresql > service, but I am still not able to restart the server and the same > error is repeating again. The best theory that comes to mind is that your start procedure is somehow starting multiple copies of the postmaster. The first one starts OK and then the second (and third?) ones fail with the lockfile complaint --- as well they should. I'm a bit afraid that your manual removals of the lockfile (which is A Bad Idea as a rule) have left you with multiple versions of the postmaster running sans lockfile. This would be very bad because you can easily end up with a corrupted database. Have you looked around with "ps" to verify that there really aren't any postgres-owned processes left over after a "failed" start? In particular, you should absolutely not see any lockfile complaints unless the PID mentioned in the message is a live process. What is PID 25372 and what is it doing? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly