Large Database/ Multiple Hard drives
Hello,
I'm running a fairly large database, several GB. My hard drive is filling
up, soon I will need a larger hard drive. I would like
to know if there is a way to put part of the postgresql database on the old
hard drive and another part on the new hard drive. I would like to avoid
raid and other complicated methods if I can.
Thank you.
Sheheryar Sewani
Houston, TX
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
If you don't want to use raid you can move
the files in $PGDATA/base to new drive
and then put symlinks to them in their
original place.
You should shut pg down before. Also
better not make any mistake
Show quoted text
On Thu, May 09, 2002 at 12:03:34PM -0500, shey sewani wrote:
Hello,
I'm running a fairly large database, several GB. My hard drive is filling
up, soon I will need a larger hard drive. I would like
to know if there is a way to put part of the postgresql database on the old
hard drive and another part on the new hard drive. I would like to avoid
raid and other complicated methods if I can.Thank you.
Sheheryar Sewani
Houston, TX_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster