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
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 |
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 |