Re: Copy a cluster from one host to an identical other

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
>
>
>
>
>

In response to

Browse pgsql-novice by date

  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