Re: Moving the database

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: "Tom Allison" <tallison(at)tacocat(dot)net>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Moving the database
Date: 2006-11-09 03:20:41
Message-ID: b35603930611081920t6403329eq45d00618bd1c0175@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 11/9/06, Tom Allison <tallison(at)tacocat(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Allison 2006-11-09 22:46:39 SSL
Previous Message Tom Allison 2006-11-09 02:08:19 Moving the database