pg_dumpall restore fails

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

Responses

Browse pgsql-bugs by date

  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