Re: Moving the database - Mailing list pgsql-novice

From Andrej Ricnik-Bay
Subject Re: Moving the database
Date
Msg-id b35603930611081920t6403329eq45d00618bd1c0175@mail.gmail.com
Whole thread Raw
In response to Moving the database  (Tom Allison <tallison@tacocat.net>)
List pgsql-novice
On 11/9/06, Tom Allison <tallison@tacocat.net> wrote:
> I would like to move the existing database to a new partion on a seperate
> physical disk.
>
> How can I move the files/directories?
>
> Can I simply use rsync -av and remount the new partition over the old directory
> space?
If the postmaster is down during the rsync, certainly.  And later on (after
you verified it's all well) umount it again and wipe the old stuff - no need
to waste space hidden under a mount-point :}


Cheers,
Andrej

pgsql-novice by date:

Previous
From: Tom Allison
Date:
Subject: Moving the database
Next
From: Tom Allison
Date:
Subject: SSL