Hi,
I'm trying to upgrade my server from Ubuntu Feisty to a later version and I think I've found a bug in pg_dumpall. The version of Postgres from Feisty is not supported in later versions so I want to dump the DB and restore after upgrade.
On the server machine I have
- Postgres 7.4.13 running with my data in it.
- Postgres 8.3.1 (latest version available on Feisty).
On my test machine I have Postgres
8.3.5.I tried to dump the 7.4.13 database using pg_dumpall from 8.3.1 and restore into 8.3.5 on my local test machine. I get the following errors at restore time:
ERROR: missing FROM-clause entry for table "icc_countries"LINE 2: ...de, icc_members.county, icc_states.name AS state, icc_countr... ^ERROR: relation "public.icc_members_test" does not existERROR: missing FROM-clause entry for table "icc_countries"LINE 2: ...name AS state, icc_states.abbrev AS state_abbrev, icc_countr... ^ERROR: relation "public.icc_members_with_admin" does not existERROR: missing FROM-clause entry for table "icc_countries"LINE 2: ...de, icc_members.county, icc_states.name AS state, icc_countr... ^ERROR: relation "public.icc_members_with_country" does not existIt looks like pg_dumpall is generating malformed SQL for the dumped views. I've attached the output from "pg_dumpall -c -s" as schema_dump.sql and the full output of that running psql 8.3.5 with that as input as psql_output.log.
Regards,
-Shaun