Thread: a question about postgresql server connection

a question about postgresql server connection

From
SongDongyan
Date:
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 kno w what should I do next step. I really appreciate any help, thank you in advance!

Best regards,
Dongyan

Dongyan Song, Msc
Uppsala University
Applied Biotechnology & Computational Science
+46(0)707204195
Flogstavagen 67E-521




微软地图实时路况,为您节省的不仅仅是时间! 立即查看!

Re: a question about postgresql server connection

From
Adrian Klaver
Date:
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@comcast.net

Re: a question about postgresql server connection

From
Tom Lane
Date:
Adrian Klaver <aklaver@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 postgresql.conf set to?

The /tmp permissions problem is unrelated to listen_addresses ...
need to fix that.

            regards, tom lane

Re: a question about postgresql server connection

From
Adrian Klaver
Date:
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@comcast.net

Re: a question about postgresql server connection

From
Dongyan Song
Date:
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


Tom Lane-2 wrote:
>
> Adrian Klaver <aklaver@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 postgresql.conf set to?
>
> The /tmp permissions problem is unrelated to listen_addresses ...
> need to fix that.
>
>             regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.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-tp23059116p23074712.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


Re: a question about postgresql server connection

From
SongDongyan
Date:
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@comcast.net
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] a question about postgresql se rver connection
> Date: Wed, 15 Apr 2009 06:46:04 -0700
> CC: yzhskdls@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
> aklaver@comcast.net


立刻下载 MSN 保护盾,保障 MSN 安全稳定! 现在就下载!

Re: a question about postgresql server connection

From
Dongyan Song
Date:
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@comcast.net
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.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.