How to move a database?

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

How to move a database?

Postby free2be1362 » Sat Jul 11, 2009 2:40 pm

I'm running out of space on my C: drive and would like to move the PT3 dabases to my D: drive to free up space on C:. How is this accomplished? and once moved, how do I tell PT3 where to look for the databases after they've been moved? (I didn't find the faq re hot swaps/networking very useful to solve my problem). I'm running under Windows Vista.

thanks, dave
free2be1362
 
Posts: 4
Joined: Tue May 27, 2008 1:54 pm

Re: How to move a database?

Postby WhiteRider » Sat Jul 11, 2009 3:03 pm

Have a look at this thread - it refers to USB drives, but I think the same will apply for another hard disk.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: How to move a database?

Postby free2be1362 » Sun Jul 12, 2009 5:09 pm

Thanks WhiteRider... the referenced procedure seems to have worked.
free2be1362
 
Posts: 4
Joined: Tue May 27, 2008 1:54 pm

Re: How to move a database?

Postby WhiteRider » Mon Jul 13, 2009 4:07 am

That's good - thanks for letting us know.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 28 guests

cron
highfalutin