I did a new install of SuSE 9.1 and had SuSE do the install via it's rpm
packages install postgresql 7.4.2. I did a pg_dump prior to this and a
restore after the new install. The database is fine.
I can access the database with OpenOffice using ODBC just fine. When I try
to connect with pgaccess, pgadmin3 or pgmanager I get this error message.
PostgreSQL error message:
Connection to database failed FATAL: no pg_hba.conf entry for host
"127.0.0.1",
user "john", database "united", SSL off
Can anyone tell me how to correct this.
thanks - John |