Re: Re: [GENERAL] postmaster does not start up

Lists: pgsql-adminpgsql-general
From: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>
To: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Perrin - Demography <aperrin(at)demog(dot)Berkeley(dot)EDU>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: [GENERAL] postmaster does not start up
Date: 2000-12-13 05:45:04
Message-ID: 200012130545.eBD5j5r06161@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin pgsql-general

Lamar Owen wrote:
>Tom Lane wrote:
>> Hmm. Where are you invoking psql from, and is it the same one you
>> compiled yourself?
>
>> ISTR that the Debian RPMs use a nonstandard location of the pgsql Unix
>> socket file, which means that an RPM psql will NOT talk to a standard
>> compilation of the postmaster, nor vice versa.
>
>Um, the Debian packages are .deb's, not RPM's. Is the standard socket
>location not /tmp? That's where the RPM's put it. I don't know about
>the DEB's -- ask Oliver.

No. /var/run/postgresql - it was necessary to move them, because long-open
sockets were being deleted from /tmp (it is, after all, a _temporary_
directory) by tmpreaper.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"For thou art my hope, O Lord GOD; thou art my trust
from my youth." Psalms 71:5


From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Perrin - Demography <aperrin(at)demog(dot)Berkeley(dot)EDU>, pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: [GENERAL] postmaster does not start up
Date: 2000-12-13 05:59:41
Message-ID: 200012130559.AAA07670@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-admin pgsql-general

> Lamar Owen wrote:
> >Tom Lane wrote:
> >> Hmm. Where are you invoking psql from, and is it the same one you
> >> compiled yourself?
> >
> >> ISTR that the Debian RPMs use a nonstandard location of the pgsql Unix
> >> socket file, which means that an RPM psql will NOT talk to a standard
> >> compilation of the postmaster, nor vice versa.
> >
> >Um, the Debian packages are .deb's, not RPM's. Is the standard socket
> >location not /tmp? That's where the RPM's put it. I don't know about
> >the DEB's -- ask Oliver.
>
> No. /var/run/postgresql - it was necessary to move them, because long-open
> sockets were being deleted from /tmp (it is, after all, a _temporary_
> directory) by tmpreaper.

/var/run seems like a good spot for it. How do you make sure clients
see it? Do you have a symlink in /tmp?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026