Thanks Tom.
I've now successfully restored my database. I manually modified the SQL to
include the missing statements. What prompted me to email the list was that
I expected the dump tool to handle the incompatibilities between the
versions automatically. I thought it was a bug that it didn't.
"Shaun Crampton" <[EMAIL PROTECTED]> writes:
> 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_member
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 runn
