Re: Copy a cluster from one host to an identical other
| От | Keith |
|---|---|
| Тема | Re: Copy a cluster from one host to an identical other |
| Дата | |
| Msg-id | CAHw75vvybQdhUF8N558+efGgbX=2eCESE_cgdArTqv+L9BfAsA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Copy a cluster from one host to an identical other ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>) |
| Ответы |
Re: Copy a cluster from one host to an identical other
|
| Список | pgsql-novice |
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 easierhttp://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 по дате отправления: