Postgres Pro
Downloads
Home   >   mailing lists

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

From Alan Hodgson
Subject Re: Migrating from 8.3 to 9.1 - date/time storage types do not match
Date
Msg-id 1366877.ZuPocA8Q6o@skynet.simkin.ca
Whole thread Raw
In response to Re: Migrating from 8.3 to 9.1 - date/time storage types do not match  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
Tree view 
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 ...

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Database Bloat
Next
From: Mike Christensen
Date:
Subject: What text format is this and can I import it into Postgres?