PDA

View Full Version : Cant acces my database anymore



krul
10-08-2010, 11:37 AM
I just tuned my postgres to optimize it. However when i started hm again, i got this message: The following error occurred when trying to open the database: Backend sent unrecognized response type

I tried to get into the database by pgAdminIII but when i enter my password i keep getting the message: Error connecting to the server: received invalid response to SSL negotiation


Any idea about what to do next?

netsrak
10-08-2010, 12:01 PM
You need to restore the original configuration of the pg_hba.conf file

krul
10-08-2010, 01:20 PM
You need to restore the original configuration of the pg_hba.conf file

ok, and how can i do that? ty for the quick answer btw

krul
10-08-2010, 02:07 PM
Ok, By now i found the pg_hba file. But i don't know what data to put in that file? There should be a back up made of that file? where can i find that?

morny
10-08-2010, 10:54 PM
Can you attach that file here please

krul
10-09-2010, 06:46 AM
Sorry, the solution actually appeared to be more simple then i thought, after rebooting my pc, al the problems where gone. Thanks for the help.