Need to move DB to external 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 DB to external hard drive

Postby eiger84 » Sun Nov 22, 2009 6:58 pm

Running out of space on my laptop and need to move my database. Can someone lay out the steps for me? Any known problems doing this? Thanks.
eiger84
 
Posts: 2
Joined: Mon Nov 03, 2008 8:33 am

Re: Need to move DB to external hard drive

Postby kraada » Sun Nov 22, 2009 8:14 pm

What sort of connection are you going to be using? If you're using a USB drive, I feel that I need to warn you: it will cause everything to slow down as the latency on the USB connection will be the bottleneck for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need to move DB to external hard drive

Postby eiger84 » Sun Nov 22, 2009 8:51 pm

kraada wrote:What sort of connection are you going to be using? If you're using a USB drive, I feel that I need to warn you: it will cause everything to slow down as the latency on the USB connection will be the bottleneck for you.


Yes, USB. Appreciate the heads up. I may need to give it a shot and see what happens.
eiger84
 
Posts: 2
Joined: Mon Nov 03, 2008 8:33 am

Re: Need to move DB to external hard drive

Postby kraada » Sun Nov 22, 2009 9:04 pm

It's doable; you'll want to follow this tutorial, just as I said, expect nontrivial performance issues.
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 30 guests

cron
highfalutin