Re: a question about postgresql server connection

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: SongDongyan <yzhskdls(at)hotmail(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: a question about postgresql server connection
Date: 2009-04-16 14:06:54
Message-ID: 200904160706.54823.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 16 April 2009 2:04:19 am SongDongyan wrote:
> Hi,
>
> Thank you for your suggestion, I set my listen_address = ' * ', and I want
> to connect to local server.
>
> After I modified listen_address from localhost to *, the error message left
> to one line:
> ***************************************************************************
>************* FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock":
> Permission denied
>
> But still, I cannot link to server.
>
> Thank you again!
>
> Best regards,
> Dongyan
>

Per Toms suggestion, you need to look at the permissions on the /tmp directory
to see why Postgres cannot open a lock file there.

--
Adrian Klaver
aklaver(at)comcast(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Guettler 2009-04-16 14:45:49 select distinct, index not used
Previous Message sandiphw 2009-04-16 13:13:33 Re: pgSql authentication problem with openLdap