BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)

From: mfwilson(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)
Date: 2012-07-12 22:16:18
Message-ID: E1SpRgI-0007HO-UN@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

The following bug has been logged on the website:

Bug reference: 6733
Logged by: Mike Wilson
Email address: mfwilson(at)gmail(dot)com
PostgreSQL version: 9.1.4
Operating system: Solaris 10
Description:

Filing this under PG914 since there isn't an option for PG9.2beta2.
Possibly this should be filed elsewhere? If so apologies in advance.

We are starting to prepare for the PG9.2 release so I have been performing
some test pg_upgrades on our existing PG8.4.2 cluster. We have a sizable
database and limited space so we have been testing upgrading our cluster
using --link mode of pg_upgrade. After performing an upgrade though the new
PG92 database has only empty tables.

Running this:
export NEWPG=/usr/postgres/postgresql-9.2.0_slony-2.1.1
export OLDPG=/usr/postgres/pg842_slony210

LD_LIBRARY_PATH=${NEWPG}/lib PATH=${NEWPG}/bin:${PATH} /usr/bin/time
${NEWPG}/bin/pg_upgrade --verbose --link \
--old-datadir=/opt/postgres/db/root/old
--new-datadir=/opt/postgres/db/root/new --old-bindir=${OLDPG}/bin/64/ \
--new-bindir=${NEWPG}/bin/ --old-port=5432 --new-port=5920 --user=postgres

This runs without errors and I am able to start the new upgraded PG92beta2
cluster. The schemas appear to be correct as well as the table definitions
and other schema objects. The tables themselves though are all empty. Not
sure what is going on

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-07-12 22:44:06 Re: BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)
Previous Message Yogesh_Sharma 2012-07-12 20:48:39 Re: BUG #6729: Install of postgresql-devel for x86_84 and i686 fails

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-07-12 22:44:06 Re: BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)
Previous Message Tom Lane 2012-07-12 21:53:54 Re: has_language_privilege returns incorrect answer for non-superuser