Re: Restoring a Full Cluster on a Different Architecture (32 x 64)

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Cc: Rodrigo Hjort <rodrigo(dot)hjort(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Restoring a Full Cluster on a Different Architecture (32 x 64)
Date: 2006-03-14 18:58:22
Message-ID: 20060314185822.GL45250@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Mar 13, 2006 at 01:36:28PM -0500, Jonah H. Harris wrote:
> What could be done in order to fix it? Is there any kind of application to
> > translate it or the only solution was to "pg_dumpall" and "pg_restore" the
> > cluster?
> >
>
> Yes, dump and restore is the best way to go.

Setting up Slony might be another option; you'd essentially be following
the procedure used to speed up a PostgreSQL upgrade that would normally
require a dump/reload.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonah H. Harris 2006-03-14 19:12:39 Re: Restoring a Full Cluster on a Different Architecture (32 x 64)
Previous Message Jim C. Nasby 2006-03-14 18:39:31 Re: random observations while testing with a 1,8B row