Postgres Pro
Downloads
Home   >   mailing lists

Re: Copy a cluster from one host to an identical other - Mailing list pgsql-novice

From Keith
Subject Re: Copy a cluster from one host to an identical other
Date
Msg-id CAHw75vvybQdhUF8N558+efGgbX=2eCESE_cgdArTqv+L9BfAsA@mail.gmail.com
Whole thread Raw
In response to Copy a cluster from one host to an identical other  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
Responses Re: Copy a cluster from one host to an identical other  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
List pgsql-novice
Tree view
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.birchall@metoffice.gov.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

 


pgsql-novice by date:

Previous
From: "Birchall, Austen"
Date:
Subject: Copy a cluster from one host to an identical other
Next
From: "Birchall, Austen"
Date:
Subject: Re: Copy a cluster from one host to an identical other