Thread: Large Database/ Multiple Hard drives

Large Database/ Multiple Hard drives

From
"shey sewani"
Date:
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


Re: Large Database/ Multiple Hard drives

From
postgres@vrane.com
Date:
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

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