One warning on migration from 8.4 --> 9.0

From: Karl Denninger <karl(at)denninger(dot)net>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: One warning on migration from 8.4 --> 9.0
Date: 2010-09-23 00:01:06
Message-ID: 4C9A98C2.3030905@denninger.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If you use Slony, expect it to lose the replication status.

I attempted the following:

1. Master and slaves on 8.4.

2. Upgrade one slave to 9.0. Shut it down, used pg_upgrade to perform
the upgrade.

3. Restarted the slave.

Slony appeared to come up, but said it was syncing only TWO tables (out
of the 33 in the working set!) Of course that didn't work very well at
all.....

Dropping the replication set and re-adding it appears to be fine, but of
course that caused a full database copy. Not too cool.

I have no idea why it only thought there were two tables in the
replication set. Very, very odd stuff....

Something to be aware of - I haven't figured out why it did this, nor do
I know if it will do the same thing to me when I attempt to upgrade the
master to 9.0 - that's something I won't attempt until the weekend at
the earliest.

Other than that running with 8.4 for the master and 9.0 for the slaves
appears to be ok.

-- Karl

Attachment Content-Type Size
karl.vcf text/x-vcard 180 bytes

Browse pgsql-general by date

  From Date Subject
Next Message TJ O'Donnell 2010-09-23 00:12:45 Re: [pgsql-sql] Daily digest v1.3328 (5 messages)
Previous Message John R Pierce 2010-09-22 23:37:16 Re: What was new in 8.4 & 8.3?