Re: Cannot connect to postgresql - Mailing list pgsql-admin

From Julius Tuskenis
Subject Re: Cannot connect to postgresql
Date
Msg-id 4A6AAE4B.5000601@nsoft.lt
Whole thread Raw
In response to Re: Cannot connect to postgresql  (Carol Walter <walterc@indiana.edu>)
List 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



Attachment

pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: Re: Cannot connect to postgresql
Next
From: rahimeh khodadadi
Date:
Subject: Re: complie postgresql with kerberos in centos