Re: a question about postgresql server connection

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: aklaver(at)comcast(dot)net
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] a question about postgresql server connection
> Date: Wed, 15 Apr 2009 06:46:04 -0700
> CC: yzhskdls(at)hotmail(dot)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
> aklaver(at)comcast(dot)net

_________________________________________________________________
MSN 表情魔法书，改变你的对话时代！
http://im.live.cn/emoticons/