Re: [GENERAL] a question about postgresql server connection

2009-04-16 Thread Adrian Klaver
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:

Re: [GENERAL] a question about postgresql server connection

2009-04-16 Thread Dongyan Song
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:

Re: [GENERAL] a question about postgresql server connection

2009-04-16 Thread SongDongyan
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 all, I installed postgresql and when I typed ./createdb mydb

Re: [GENERAL] a question about postgresql server connection

2009-04-16 Thread Dongyan Song
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

[GENERAL] a question about postgresql server connection

2009-04-15 Thread SongDongyan
Hi all, I installed postgresql and when I typed ./createdb mydb, it gave error message: * createdb: could not connect to database postgres: could not connect to server: No

Re: [GENERAL] a question about postgresql server connection

2009-04-15 Thread Adrian Klaver
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

Re: [GENERAL] a question about postgresql server connection

2009-04-15 Thread Tom Lane
Adrian Klaver akla...@comcast.net 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