PDA

View Full Version : postgres will not boot up after blackout.



raps27
12-29-2009, 06:00 AM
i recently had a blackout and now my postgres will not start up at all. when i try to start it up manually my computer says it failed to start the program as it could not be started in the alloted time. anyone else had these problems ive tried reinstalling and creating new databases but it doesnt seem thats the problem. it seems postgres as a service just will not boot up. any ideas?

Patvs
12-29-2009, 06:47 AM
Install PostgreSQL 8.4.2 on port 5433.
Open dbcontrolpanel.exe, change the 5432 to 5433--> connect--> create a new UTF8 database.

raps27
12-29-2009, 10:57 AM
i've uninstalled the other postgres i had on it but now when i try and install the 4.2 verson it says please provide a password for the database super user and everything i enter in from my last one it doesnt accept even though ive uninstalled it anyway. or is the database still there?

netsrak
12-29-2009, 02:23 PM
The data folder may still be there, you will get a warning about this later during the installation.

For your current problem you should delete the old postgres user:
click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista/Windows 7, rightclick and choose "Run as Administrator".

A black box should appear. Type 'net user postgres /del' (without the quotes) and press enter.

The user is now deleted and you can install PostgreSQL assigning a new password.

raps27
12-29-2009, 07:49 PM
thanks so much for that fixed it. however is it possible to transfer hands from one database to the other?

netsrak
12-30-2009, 06:09 AM
Only via export/import: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173