Need to move PostreSQL to new hard drive

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

Need to move PostreSQL to new hard drive

Postby DrewOnTilt » Fri Nov 07, 2008 9:35 am

Hi all -

I just installed a second hard drive on my PC, and set the new drive as the master drive. I need to move all of my PostrgeSQL data from the slave drive to the master drive. I installed PostrgeSQL 8.2.6 on the master drive. Is moving the databases as simple as copy/pasting the PostgreSQL/8.2/data folder from the slave to the master? That almost seems too easy.
DrewOnTilt
 
Posts: 134
Joined: Fri Jan 25, 2008 6:34 pm

Re: Need to move PostreSQL to new hard drive

Postby kraada » Fri Nov 07, 2008 10:39 am

Please see this thread which talks about how to accomplish exactly what you're trying to do.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need to move PostreSQL to new hard drive

Postby DrewOnTilt » Fri Nov 07, 2008 8:45 pm

kraada wrote:Please see this thread which talks about how to accomplish exactly what you're trying to do.


Hi Kraada - thanks, but when I try to open that link, I get a message that says that I am not authorized to view the forum. Is the thread the same as the one summarized by Dave here:
viewtopic.php?f=15&t=13122&p=61335&hilit=move+postgresql+database#p61335

??

Thanks.
DrewOnTilt
 
Posts: 134
Joined: Fri Jan 25, 2008 6:34 pm

Re: Need to move PostreSQL to new hard drive

Postby kraada » Sat Nov 08, 2008 9:48 am

Oops, sorry, yes it is :oops:
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 27 guests

cron