Thread:
Hi, I have a problem with the postmaster. When I try to start it with "/etc/init.d/postgresql start", i get the message [FAILED]. When I try to stop it, it's the same thing. Of course, when i want to connect to the database with psql ..., i have the message "can't connect to server ....". I have already started it before and i don't reboot since. The command "netstat -na|grep 5432" don't give any answer. Moreover, i delete the postmaster.pid file because I thought it was the problem but it always failed. Can you help me ? Thanks G�rard TOURRES ---------------------------------------- Computers are like air-conditioners, They stop working properly When you open windows ------------------------------------------
Am Fre, 2003-05-23 um 09.46 schrieb Gerard TOURRES: > Hi, > > I have a problem with the postmaster. When I try to start it with > "/etc/init.d/postgresql start", i get the > message [FAILED]. When I try to stop it, it's the same thing. Of > course, when i want to connect to the database > with psql ..., i have the message "can't connect to server ....". I > have already started it before and i don't reboot since. > > The command "netstat -na|grep 5432" don't give any answer. Moreover, i > delete the postmaster.pid file because I thought it > was the problem but it always failed. > > Can you help me ? What Distribution are you using ? What is the output of the logfiles (e.g./var/log/syslog /var/log/messages /var/log/postgresql/* ) ? bye -- e-Trolley Sayegh & John, Nabil Sayegh Tel.: 0700 etrolley /// 0700 38765539 Fax.: +49 69 8299381-8 PGP : www.e-trolley.de
On Fri, 2003-05-23 at 08:46, Gerard TOURRES wrote: > Hi, > > I have a problem with the postmaster. When I try to start it with > "/etc/init.d/postgresql start", i get the > message [FAILED]. When I try to stop it, it's the same thing. Of > course, when i want to connect to the database > with psql ..., i have the message "can't connect to server ....". I > have already started it before and i don't reboot since. > > The command "netstat -na|grep 5432" don't give any answer. Moreover, i > delete the postmaster.pid file because I thought it > was the problem but it always failed. You need to dig into /etc/init.d/postgresql to find out what it is doing. You don't say what system you are on. Eventually, that program is going to be running the postmaster, after setting up the environment. You need to set up the same environment and then run postmaster directly, so that you can see what errors there are. It may be that the errors have been logged somewhere; if you can find the log, you may not need to run postmaster directly... -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "But where shall wisdom be found? And where is the place of understanding? It cannot be gotten for gold, neither shall silver be weighed for the price thereof. Whence then cometh wisdom? and where is the place of understanding? ...Behold the fear of the Lord, that is wisdom; and to depart from evil is understanding." Job 12,15,20,28
> I have a problem with the postmaster. When I try to start it with > "/etc/init.d/postgresql start", i get the > message [FAILED]. When I try to stop it, it's the same thing. Of > course, when i want to connect to the database > with psql ..., i have the message "can't connect to server ....". I > have already started it before and i don't reboot since. Check the log info. If you have not enabled the log, edit /etc/init.d/postgresql and pass '-l logfile' to pg_ctl start and stop command. Restart postgresql and check the logfile for what goes wrong and i hope you will find it there. regards, bhuvaneswaran