Re: Cannot connect to postgresql - Problem solved - Why / How?

Problem solved.  I don't know why!

Nothing in the pg_hba.conf file or the postgresql.conf file appeared
to be a problem.  I was still getting password authorization
failures.  I thought the password had changed, perhaps, without my
knowing it.  I changed the password to what it was originally was -
and it worked!  Then I tried to get into my test database with my test
user.  It didn't work.  Then I reset the password to what it already
was and it worked. Then I tried this with several other accounts.  It
behaved the same way each time.

Does anyone know what might have caused this behavior?

Carol
On Jul 24, 2009, at 1:39 PM, Carol Walter wrote:

> 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
>>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin