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