Restoring a database without a proper backup?

[jackdninja]

Hi all.

I recently reformatted my computer (running off of 1 harddisk) and I actually backed up the complete drive to USB but I forgot to backup the sql database from pokertracker.

I looked around and it seems like if you want to import another database you have to back it up. Unfortunately this is not an option for me. Are there some files I can copy from my backup to the fresh new SQL folders that would restore my old database?

Thanks,
Jack

[WhiteRider]

Please read this thread which is about the same sort of issue.

[jackdninja]

Thanks, I tried the first thing (moving over the 8.3 folders) but it couldn't connect. After work I'm going to try the reinstalling of SQL. I'll update later!

[kraada]

Good luck - keep me posted!

[jackdninja]

So I've been messing around with my databases and I uninstalled SQL and reinstalled and I cannot get it to connect to the backed up server.

When I try from the installer it says my username/password is wrong.

When I try from pokertracker I get a popup window "Configure postgreSQL Database" and when i try to browse databases I get:

"
Unable to login to database (template1). Reason: could not connect to server: Connectin refused (0x0000274D/10061). Is this server running on host "???" and accepting TCP/IP connections on port 5432?
"

I'm trying the default postgres / dbpass combo and no luck. Maybe in my stupidity 2 or so years ago (when I first made the DB) I changed the username or pass and forgot to write it down =(.

Does this mean I'm screwed?

[kraada]

Not if the server is actually running. Click Start, type Services.msc and hit enter. Locate PostgreSQL from the list, is the server running? If not, does it start?