PDA

View Full Version : screwed up postresql



greycubed
07-06-2009, 11:50 PM
I recently bought a new hard drive, and was going to put postresql onto it.

So I dragged the entire postresql folder onto the new hard drive, but I couldn't get the service to start because I couldn't figure out how to edit the path from C:/... to F:/... Under properties it just wouldn't let me edit.

So I dragged the folder back onto the C drive and now when I start postresql it takes a long time (like 2 minutes) to start and then I get this error "The PostreSQL Database Server 8.2 service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service."

When I restart the computer it just shows as "starting" indefinitely. Same if I let HEM attempt to start the service.

Please help. =[

fozzy71
07-07-2009, 08:48 AM
You have to uninstall SQL from the C drive completely, and reinstall it to your new drive.

For uninstalling SQL please follow these steps:

-Download Revo Uninstaller and use it to uninstall PostgreSQL. After it uninstalls it will give you options to select and delete all the associated registry entries.
- manually delete the Program Files\Postgresql folders
- run the command - start > run > cmd >


net user postgres /delete

- reboot.
- install again, with your firewall uninstalled or turned off if windows firewall

Now pick the proper drive/path when installing.


You may also want to read these FAQs:

How do I re-install PostgreSQL and use a previous database? (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177)


I've recently bought a new hard drive and I would like to transfer my Holdem Manager database to the new hard drive, as it is taking up too much space on my old one. How would I go about doing this? (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=101)