Re: Migrating from 8.3 to 9.1 - date/time storage types do not match

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Migrating from 8.3 to 9.1 - date/time storage types do not match
Date: 2012-08-22 23:55:42
Message-ID: 1366877.ZuPocA8Q6o@skynet.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, August 22, 2012 02:43:05 PM Alan Hodgson wrote:
> The most likely way to get this done is with Slony. Setup a Slony slave,
> upgrade the slave to 9.1 with a dump/reload, run it and let Slony catch it
> up, and then promote it to be the Slony cluster master and switch your
> clients over.
>

Or, of course, just setup a clean 9.1 and let Slony populate it. Duh. Too long
since I did that ...

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2012-08-23 00:23:09 What text format is this and can I import it into Postgres?
Previous Message David Johnston 2012-08-22 23:30:31 Re: Database Bloat