Skip site navigation (1) Skip section navigation (2)

Re: Cannot connect to postgresql

From: Julius Tuskenis <julius(at)nsoft(dot)lt>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Cannot connect to postgresql
Date: 2009-07-25 07:03:39
Message-ID: 4A6AAE4B.5000601@nsoft.lt (view raw or flat)
Thread:
Lists: pgsql-admin
Hello, Carol

try command "netstat -l --numeric-ports" to see all ports your system 
listens to. You should see something like this:
tcp        0      0 *:5432                  *:*                     LISTEN
If  you see the line - your postgres is configured to listen. It is 
likely to be true as you can connect to postgres localy.
Then from other computer try telneting the port. If you will succeed - 
then I'd say theres something wrong with your pg_hba.conf.
Also see postgres log files. Maybe they will tell you what is wrong.


Carol Walter rašė:
> I'm running Solaris 10.
>
> Carol
>
> On Jul 24, 2009, at 3:07 AM, Julius Tuskenis wrote:
>
>>
>>> #--------------------------------------------------------------------------- 
>>>
>>> # CONNECTIONS AND AUTHENTICATION
>>> #--------------------------------------------------------------------------- 
>>>
>>>
>>> # - Connection Settings -
>>>
>>> #listen_addresses = 'localhost'        # what IP address(es) to 
>>> listen on;
>>>                    # comma-separated list of addresses;
>>>                    # defaults to 'localhost', '*' = all
>>>
>>>
>>> listen_addresses = '*'
>>>
>>> #port = 5432
>> That seems ok. I don't know what OS you use, but check if postgres is 
>> listening to port 5432. Also check your firewall settings.
>>
>> -- 
>> Julius Tuskenis
>> Programavimo skyriaus vadovas
>> UAB nSoft
>> mob. +37068233050
>>
>
>


-- 
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050


In response to

pgsql-admin by date

Next:From: TRAN THI NGOC MAIDate: 2009-07-26 13:04:26
Subject: Please, help me configuring RFT
Previous:From: Carol WalterDate: 2009-07-24 17:39:56
Subject: Re: Cannot connect to postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group