Re:

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(dot)Elphick(at)lfix(dot)co(dot)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