Re: a question about postgresql server connection - Mailing list pgsql-general

From Dongyan Song
Subject Re: a question about postgresql server connection
Date
Msg-id 23081602.post@talk.nabble.com
Whole thread Raw
In response to Re: a question about postgresql server connection  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general
Hi,

Thank you for all suggestions, I fixed this problem by change the owner of
/tmp/.s.PGSQL.5432.lock file.

# chown postgres /tmp/.s.PGSQL.5432.lock

and it is done.

Best wishes,
Dongyan


Adrian Klaver wrote:
>
> 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@comcast.net
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>


-----
Dongyan Song, Msc
Medical informatics, Uppsala University, Sweden
--
View this message in context:
http://www.nabble.com/a-question-about-postgresql-server-connection-tp23059116p23081602.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: benoît carpentier
Date:
Subject: [ANNOUNCE] Benetl, a free ETL tool for files using postgreSQL, is out in version 2.7
Next
From: ray
Date:
Subject: Re: Part way there, how do I complete it