PDA

View Full Version : Optimizing PostgreSQL breaks it



steel108
10-22-2010, 08:08 PM
I'm using HEM to fine tune PostgreSQL. Everytime I do, everything breaks. I can longer connect to my database. This has happened 4 times (finally figured out that was the problem) without fail. How do I fix it without reimporting every hand again!

morny
10-23-2010, 12:57 AM
I presume you mean that Postgresql wont start?

Can you try to restart the service again via Control Panel > Administrative Tools > Services and look for PostgreSQL and click start. It will time out after several minutes and give an error. Then go to the event viewer and under applications in there it should give an error message, can you copy and paste those details here or post a screenshot

How to open event viewer in Vista or Windows 7
Event Viewer in Windows 7 | help.artaro.eu (http://help.artaro.eu/index.php/windows-7/essential-windows-7-administration/event-viewer-in-windows-7.html)