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

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

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

Postby Mullin » Mon Oct 13, 2008 2:27 pm

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,
Mullin
 
Posts: 18
Joined: Fri Mar 14, 2008 10:33 am

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

Postby WhiteRider » Mon Oct 13, 2008 3:55 pm

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.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

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

Postby Mullin » Tue Oct 14, 2008 1:45 am

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-)
Mullin
 
Posts: 18
Joined: Fri Mar 14, 2008 10:33 am

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

Postby WhiteRider » Tue Oct 14, 2008 3:09 am

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).
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

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

Postby Mullin » Tue Oct 14, 2008 7:19 am

No problems, thanks for keeping me up to date.
Mullin
 
Posts: 18
Joined: Fri Mar 14, 2008 10:33 am


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 88 guests

cron
highfalutin