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 Dongyan Song, Msc Uppsala University Applied Biotechnology & Computational Science +46(0)707204195 Flogstavagen 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 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 such file or > > directory Is the server running locally and accepting > > connections on Unix domain socket "/tmp/.s.PGSQL.5432"? > > > > Then I checked /etc/init.d file, and I got postgresql-8.3 in this > > directory, then I used $ sudo ./postgresql-8.3 start, which gave error > > message: > > *************************************************************************** > >* LOG: could not bind IPv4 socket: Address already in use > > > > HINT: Is another postmaster already running on port 5432? If not, wait a > > few seconds and > > > > retry\. > > > > FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission > > denied > > > > But before it, I have already add an line below the IPv4 connection, which > > looks like: # IPv4 local connections: > > host all all 127.0.0.1/32 trust > > host all all 130.238.209.11/1 trust > > > > I got my IP address from ifconfig. After that, I really do not know what > > should I do next step. I really appreciate any help, thank you in advance! > > First are you trying to connect to a local server or a remote server? > Second what is listen_addresses in postgresql.conf set to? > > > > > Best regards, > > Dongyan > > > > Dongyan Song, Msc > > Uppsala University > > Applied Biotechnology & Computational Science > > +46(0)707204195 > > Flogstavagen 67E-521 > > > > > > > > _________________________________________________________________ > > 上Windows Live 中国首页，下载最新版 MSN！ > > http://im.live.cn/ > > > > -- > Adrian Klaver > akla...@comcast.net _________________________________________________________________ MSN 表情魔法书，改变你的对话时代！ http://im.live.cn/emoticons/
