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
67E-521
> From: akla...@comcast.net
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] a question about postgresql server connection
> Date: Wed, 15 Apr 2009 06:46:04 -0700
> CC: yzhsk...@hotmail.com
>
> On Wednesday 15 April 2009 5:30:29 am SongDongyan wrote:
> > Hi a
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: coul
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:
> ***
Adrian Klaver writes:
> On Wednesday 15 April 2009 5:30:29 am SongDongyan wrote:
>> FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission
>> denied
> First are you trying to connect to a local server or a remote server?
> Second what is listen_addresses in postgresql.conf set to?
On Wednesday 15 April 2009 5:30:29 am SongDongyan wrote:
> Hi all,
>
> I installed postgresql and when I typed ./createdb mydb, it gave error
> message:
> ***
>** createdb: could not
