Hi Tom, Further to the below mail.
Below is the status of postgresql startup status. /etc/rc.d/init.d/postgresql status postmaster (pid 25114 23600 16118 15969 15968 15967 15936 15927 14351 6706 2700) is running... Thanks&Regards, -Jawad -----Original Message----- From: Hussain Jawad-FXRM43 Sent: Tuesday, November 20, 2007 1:04 AM To: 'Tom Lane' Cc: pgsql-bugs@postgresql.org Subject: RE: [BUGS] Start up error Hi Tom, Thank you for your time. Below are the answers for your queries. 1)I am using /etc/rc.d/init.d/postgresql stop/start to stop and start the postgresql service. 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 3)There is no process running with PID 25372. I have been asked to reboot the server to fix this, what precautions should be taken before reboot to get the postgresql DB working after reboot. Is really reboot will fix the issue.Could you please suggest. Thanks & Regards, -Jawad. -----Original Message----- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Saturday, November 17, 2007 9:48 PM To: Hussain Jawad-FXRM43 Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] Start up error "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 2: Don't 'kill -9' the postmaster
