Re: Cannot connect to postgresql

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