"Hussain Jawad-FXRM43" <FXRM43@motorola.com> 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 majordomo@postgresql.org so that your message can get through to the mailing list cleanly

"Hussain Jawad-FXRM43" <FXRM43@motorola.com> writes: > 2)There are several postgresql process running after a failed > restart.Below are the proccesess > ps -ef|grep post > root 730 30758 0 12:22 pts/2 00:00:00 grep post > postgres 2700 15927 73 12:00 ? 00:16:15 postgres: cscti csctools > [local] DELETE > postgres 6706 15927 72 12:00 ? 00:15:42 postgres: cscti csctools > [local] DELETE > postgres 14351 15927 69 12:02 ? 00:13:38 postgres: cscti csctools > [local] DELETE > postgres 15927 1 0 11:58 ? 00:00:05 /usr/bin/postmaster -p > 5432 -D /var/lib/pgsql/data > postgres 15936 15927 0 11:58 ? 00:00:00 postgres: logger process > postgres 15967 15927 0 11:58 ? 00:00:00 postgres: writer process > postgres 15968 15927 0 11:58 ? 00:00:00 postgres: stats buffer > process > postgres 15969 15968 0 11:58 ? 00:00:00 postgres: stats > collector process > postgres 16118 15927 73 11:58 ? 00:17:23 postgres: cscti csctools > [local] DELETE > postgres 23600 15927 65 12:08 ? 00:09:25 postgres: cscti csctools > [local] DELETE That hardly looks like a "failed restart". I can't help wondering if you were looking at the wrong log file. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend