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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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