Re: Copy a cluster from one host to an identical other

That works yes. Just be sure to call pg_start_backup() on the master before
starting the tar and then pg_stop_backup() when you're done.
You can also use the pg_basebackup tool to help make it a little easier
http://www.postgresql.org/docs/9.2/static/app-pgbasebackup.html

On Fri, Sep 26, 2014 at 10:32 AM, Birchall, Austen <
austen(dot)birchall(at)metoffice(dot)gov(dot)uk> wrote:

> If I want to copy a cluster from one host to an identical other (same
> size, disk layout etc.) am I right to assume that the can just:
>
>
>
> 1. Tar up /var/lib/pgsql on the original
>
> 2. ftp to the target
>
> 3. Extract tarfile into /var/lib/pgsql on the target
>
> 4. Start PostgreSQL
>
>
>
> Thanks
>
>
>
> Austen
>
>
>
> Austen Birchall Senior Database Administrator
> * Met Office* FitzRoy Road Exeter EX1 3PB United Kingdom
>
>
>