PDA

View Full Version : Simple Postgre SQL problem that I'm sure you guys can fix



xplore
05-03-2010, 07:27 PM
So naturally it's just the failed to connect to DB, can't start service, started service .. try again.

Now I know why this is happening, i deleted the user 'postgres' from the accounts page in control panel.

I didn't know it was pertinent to the program working as it's just a DB program, why would it need it's own account in Windows to run? It should just run under a username within the account active on Windows right?

Anyway, i'm running Vista x64 and have all updates installed.

I use ESET for AV and a basic firewall I have control over and allowed Postgre full access.

xplore
05-03-2010, 09:00 PM
bump

netsrak
05-04-2010, 05:28 AM
The postgres user is needed for the administration of the database functions and the postgres service.
You should reinstall postgresql trying to reconnect to your database:
FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database)

xplore
05-04-2010, 12:42 PM
Okay, i just uninstalled and reinstalled the prog, created a new DB and imported my archived hands and all is working.