So we have a large TB database that we need to migrate to 9.1 and I'm
wondering if there's a way to do this process in stages.
Since the date/time storage types changes between 8.3 and 8.4, I
realize we'll have to dump the database and my plan is to create a
backup using pg_start_backup(), run
On 08/22/12 2:17 PM, Scott Briggs wrote:
So we have a large TB database that we need to migrate to 9.1 and I'm
wondering if there's a way to do this process in stages.
Since the date/time storage types changes between 8.3 and 8.4, I
realize we'll have to dump the database and my plan is to
On Wednesday, August 22, 2012 05:17:10 PM Scott Briggs wrote:
So we have a large TB database that we need to migrate to 9.1 and I'm
wondering if there's a way to do this process in stages.
Since the date/time storage types changes between 8.3 and 8.4, I
realize we'll have to dump the
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.