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