Thread: Postgres startup

Postgres startup

From
"Belcher, Jim"
Date:
Hello,

We are using version 7.0, and I have noticed that quite often,
postgres fails to start(as much as 50%).  When it does start
everything seems fine.  Any ideas as to why this is occuring.

All installation is done from the downloaded rpms, so nothing
is custom.

Thanks

Jim

Re: Postgres startup

From
"ADBAAMD"
Date:
Belcher, Jim wrote:

>
> We are using version 7.0, and I have noticed that quite often,
> postgres fails to start(as much as 50%).  When it does start
> everything seems fine.  Any ideas as to why this is occuring.

    Don't you have any logs from failed attempts to start?



--
  _
/ \   Leandro Guimarães Faria Corsetti Dutra         +55 (11) 3040 8913
\ /   Amdocs at Bell Canada                          +1 (514) 786 87 47
  X    Support Center, São Paulo, Brazil          mailto:adbaamd@bell.ca
/ \   http://terravista.pt./Enseada/1989/    mailto:leandrod@amdocs.com



Re: Postgres startup

From
"ADBAAMD"
Date:
Belcher, Jim wrote:

> I will check them, but not sure where they are

    It is distribution-dependent, if you've got your packages from the OS
distribution.

> From: ADBAAMD [mailto:adba.amdocs@bell.ca]
>
>
> Belcher, Jim wrote:
>
>> We are using version 7.0, and I have noticed that quite often,
>> postgres fails to start(as much as 50%).  When it does start
>> everything seems fine.  Any ideas as to why this is occuring.
>
>     Don't you have any logs from failed attempts to start?



--
  _
/ \   Leandro Guimarães Faria Corsetti Dutra         +55 (11) 3040 8913
\ /   Amdocs at Bell Canada                          +1 (514) 786 87 47
  X    Support Center, São Paulo, Brazil          mailto:adbaamd@bell.ca
/ \   http://terravista.pt./Enseada/1989/    mailto:leandrod@amdocs.com



Re: Postgres startup

From
Dave Edmondson
Date:
On Tue, Apr 03, 2001 at 09:38:48AM -0400, Belcher, Jim wrote:
> Hello,
>
> We are using version 7.0, and I have noticed that quite often,
> postgres fails to start(as much as 50%).  When it does start
> everything seems fine.  Any ideas as to why this is occuring.
>
> All installation is done from the downloaded rpms, so nothing
> is custom.

I've modified the PostgreSQL startup file to include this:

if [ -x /tmp/.s.PGSQL.* ]
    then
    rm /tmp/.s.PGSQL.*
fi

This is for a FreeBSD install, so something may be different, though I
doubt it.

If Postgres wasn't shut down gracefully, this will remove its old lockfile.
(I've noticed Postgres doesn't log anything about this, it just refuses to
start). Also, clearing /tmp on startup might also do the trick. So, if
you were having trouble with Postgres not coming up after system crashes,
this might be the problem. (This is what fixed it for me).

--
David Edmondson <david@jlc.net>               http://www.landofsunshine.net
"A metaphysician is a blind man in a dark room looking for a black cat that
isn't there, and a theologian is one who finds the cat."