PDA

View Full Version : HDD with DB is broke, cannot create new DB on original HDD.



Antster2
11-04-2012, 07:35 PM
Hi, im sorry if this is not the right place to post this, i hope it is.

Ive had my DB stored on my SSD for the past months, recently it broke and now disconnects after about 10 mins of the PC running.

I tried installing Postgres8.3 (which is the same version as the one on the broken SSD) on my original HDD.

When i go to install it asks me: specify the directory where posgres will be installed, then it asks me to specify the directory where it will store my data. (I left the directories as the default shown, and they are set to the original HDD - not the broken SSD)

So i click next and it asks for a password. When i click next it tells me that i need a password, so i entered "1234" and it tells me that
"The password specified was incorrect. Please enter the correct password for the postgres windows user account."

When i run HEM i get the error on start-up, saying "Failed to establish a connection to '127.0.0.1'" (which i assume is the DB from the broken SSD)

When i click "OK" HEM pops up and away quickly and i am shown the "Database Control Panel".

This window has the information for the broken database and when i click connect, it tells me that "a connection to postresQL could not be made. Would you like to have HEM attempt to start the service?" if i click yes it tells me that it was unable to start the service.


I would like to be able to create a new DB on the HDD and just forget about the SSD for the meantime.

I am really lost here and would appreciate some help on this problem.

Thank You.

ps. sorry for bad punctuation

sideshow
11-04-2012, 08:02 PM
Hi,

1) Go to C:\Program Files\PostgreSQL\8.x\data, move the pg_hba file to your Desktop and open it with notepad.
2) Scroll to the bottom and change all md5 to trust. Save and close the file.
3) Move the file back to the data folder.
4) Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.


If the problem persists

This is usually a firewall or windows update issue and the following guide step by step:

http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+ - Can’t Connect / Failed to Start PostgreSQL

Thanks

Antster2
11-04-2012, 08:28 PM
Hi Slideshow, thanks for your speedy reply, There is no folder in program files called "PostgresQL", that was stored on the other broken SSD in "B:\Program Files\PostgreSQL\8.x\data" not "C:\Program Files\PostgreSQL\8.x\data".

I am not able to access my broken SSD therefore cannot edit said file.

Patvs
11-05-2012, 12:12 AM
You can either edit the system's registry, so it will stop using the B:/ folder, read: http://faq.holdemmanager.com/questions/368/MoveDatabaseToAnotherHardDriveOrPartition

Or you can reinstall a different version of PostgreSQL to the HDD (for example SQL 8.2, 8.4, or 9.0) to a different port (5433) and use that instead.

Antster2
11-05-2012, 01:03 AM
You can either edit the system's registry, so it will stop using the B:/ folder, read: http://faq.holdemmanager.com/questions/368/MoveDatabaseToAnotherHardDriveOrPartition

Or you can reinstall a different version of PostgreSQL to the HDD (for example SQL 8.2, 8.4, or 9.0) to a different port (5433) and use that instead.

Thanks man, that was just the fix!

Thank you kindly sir.

Antster2
11-05-2012, 01:05 AM
You can either edit the system's registry, so it will stop using the B:/ folder, read: http://faq.holdemmanager.com/questions/368/MoveDatabaseToAnotherHardDriveOrPartition

Or you can reinstall a different version of PostgreSQL to the HDD (for example SQL 8.2, 8.4, or 9.0) to a different port (5433) and use that instead.

This was the solution I was looking for, thank you very much!

**SOLVED**