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 CAHw75vtCsa=QmHWN1ErO94WD_hQ3iU6NWrq2-3vFUPYcEm7D=w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Copy a cluster from one host to an identical other  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
Список pgsql-novice
If you're shutting it down completely, then yes, just tar'ing and copying should work as long as the destination is a similar architecture (you can't go from a 32-bit to a 64-bit system with a file copy).

On Fri, Sep 26, 2014 at 11:27 AM, Birchall, Austen <austen.birchall@metoffice.gov.uk> wrote:

Hi again

Actually I meant to said the original is a non WAL mode dev cluster so I will shut it down before starting the tar.

Also I would use pgdump but there is a known issue with this potentially not working with version of the application we are using & Postgres 8.4 (yes, an upgrade Project is underway!!!)

 

Austen

 Austen Birchall  Senior Database Administrator
Met Office
FitzRoy Road Exeter EX1 3PB United Kingdom

 

 


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Birchall, Austen"
Дата:
Сообщение: Re: Copy a cluster from one host to an identical other
Следующее
От: William Morgan
Дата:
Сообщение: setting query timeout as part of the query