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