On Tue, Nov 12, 2013 at 11:25 AM, Stephen Frost <sfr...@snowman.net> wrote: > > How was this upgrade done? If you used pg_upgrade, what version of the > pg_upgrade code did you use? As I recall, there was a bug in older > versions which could exhibit in this way.. > > http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix >
As mentioned in the original post... "the new database cluster was created by dumping global settings using pg_dumpall and then dumping each database individually." We haven't been able to use pg_upgrade as we rely heavily on PostGIS and do hard upgrades via pg_dump and postgis_restore.pl when we upgrade. Cheers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers