Re: Filesystem level backup and 32 / 64 bit

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: NTPT <ntpt(at)centrum(dot)cz>
Cc: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Filesystem level backup and 32 / 64 bit
Date: 2005-03-15 16:35:06
Message-ID: 1110904505.28555.138.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2005-03-15 at 07:29, NTPT wrote:
> I have situation where I have one box with linux native 64 bit distribution
> (Gentoo on AMD) running pg 8.x and other box running a 32 bit distro
> running version of pg 8.x
>
> Is it posssible to take a "filesystem level backup" (copyiing all in
> $PGDATA directory) from 64 bit system and use it as $PGDATA in the native 32
> bit system with the same version of postgresql ?
>
>
> Ie to have one big 64 bit server and eventually a small but cheap 32 bit box
> as an emergency backup ?

Following up on what Tom wrote, I'd suggest using Slony-I to keep the
two machines in sync.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Frederic Massot 2005-03-15 16:35:27 Re: Dump all in several files
Previous Message javier wilson 2005-03-15 16:32:38 Re: Dump all in several files