From: | Dongyan Song <yzhskdls(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: a question about postgresql server connection |
Date: | 2009-04-16 16:31:14 |
Message-ID: | 23081602.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)comcast(dot)net
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2009-04-16 16:42:48 | Re: select distinct, index not used |
Previous Message | Tom Lane | 2009-04-16 15:50:51 | Re: [GENERAL] Performance of full outer join in 8.3 |