From: | Keith <keith(at)keithf4(dot)com> |
---|---|
To: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Copy a cluster from one host to an identical other |
Date: | 2014-09-26 15:33:13 |
Message-ID: | CAHw75vtCsa=QmHWN1ErO94WD_hQ3iU6NWrq2-3vFUPYcEm7D=w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)birchall(at)metoffice(dot)gov(dot)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
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | William Morgan | 2014-09-30 19:52:49 | setting query timeout as part of the query |
Previous Message | Birchall, Austen | 2014-09-26 15:27:18 | Re: Copy a cluster from one host to an identical other |