Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-hackers by date

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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group