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 CAHw75vtCsa=QmHWN1ErO94WD_hQ3iU6NWrq2-3vFUPYcEm7D=w@mail.gmail.com
Whole thread Raw
In response to Re: Copy a cluster from one host to an identical other  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
List pgsql-novice
Tree view
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 by date:

Previous
From: "Birchall, Austen"
Date:
Subject: Re: Copy a cluster from one host to an identical other
Next
From: William Morgan
Date:
Subject: setting query timeout as part of the query