From: | "Shaun Crampton" <shaun(at)cantab(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | pg_dumpall restore fails |
Date: | 2008-11-23 20:25:54 |
Message-ID: | ab7605e50811231225t12acfc9eu287a6786236b0014@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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 exist
ERROR: 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 exist
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_with_country" does not exist
It 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
Attachment | Content-Type | Size |
---|---|---|
schema_dump.sql | text/x-sql | 18.8 KB |
psql_output.log | text/x-log | 2.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2008-11-24 06:39:48 | Re: BUG #4547: sort columns in \d |
Previous Message | Tom Lane | 2008-11-23 19:11:44 | Re: BUG #4547: sort columns in \d |