Page 1 of 1

Main HD crash, DB already on 2nd drive, recovery?

PostPosted: Mon Oct 13, 2008 2:27 pm
by Mullin
My main HD died the other day, taking PostgreSQL with it, however the multiple databases are located on another drive.

I'm sure I've seen a post here ages ago (possibly from _dave_) explaining how to recover the dbs. I can find the posts explaining how to create a DB on another drive, which is what I used in the first place, but cannot for the life of me find one pertaining to making an existing DB work on a new install of PostgreSQL.

I'm pretty sure I know all the details (db name, password, host name etc), help would be greatly appreciated.

Other possibly relevant details:

Vista
UAC is already disabled
Comfortable using command prompt with sufficient direction :)
I have two DBs on the secondary drive in the same location (eg. d:\PT3db) just installed using a different TABLESPACE name with the same LOCATION (not sure if this was wise, obv not an expert)

Cheers,

Re: Main HD crash, DB already on 2nd drive, recovery?

PostPosted: Mon Oct 13, 2008 3:55 pm
by WhiteRider
I'm not sure of the exact procedure, so rather than trying a half-assed explanation, I'll get someone to take a look at this thread for you.

Re: Main HD crash, DB already on 2nd drive, recovery?

PostPosted: Tue Oct 14, 2008 1:45 am
by Mullin
Thanks WR,

Any idea on an ETA? Not trying to push, just that my game relies heavily on stats and I'm not confident playing without them.

I play for a living so I'm asking more out of necessity than impatience.

Thanks again, and please don't read this as a complaint ;)

Mullin 8-)

Re: Main HD crash, DB already on 2nd drive, recovery?

PostPosted: Tue Oct 14, 2008 3:09 am
by WhiteRider
Sorry, I posted a message for someone to look at it, they must have been busy - I'll send another message and try to make sure you get a response later today (most of the support guys are in the US, so it won't be for a while yet).

Re: Main HD crash, DB already on 2nd drive, recovery?

PostPosted: Tue Oct 14, 2008 7:19 am
by Mullin
No problems, thanks for keeping me up to date.