Chris Lee <Chrislee@centurycity.com.hk> writes:
> When I try to restore dump (using 7.4.2 pg_dumpall) from 7.1.2, I got the
> following error:
> [1-1] ERROR: relation "pg_relcheck" does not exist
> [2-1] ERROR: relation "pgadmin_checks" does not exist
> [3-1] ERROR: relation "pgadmin_checks" does not exist
> [4-1] ERROR: column pg_group.oid does not exist
> [5-1] ERROR: relation "pgadmin_groups" does not exist
> [6-1] ERROR: relation "pgadmin_groups" does not exist
> [7-1] ERROR: column x.indislossy does not exist
> [8-1] ERROR: relation "pgadmin_indexes" does not exist
> [9-1] ERROR: relation "pgadmin_indexes" does not exist
> [10-1] ERROR: column l.lancompiler does not exist
> [11-1] ERROR: relation "pgadmin_languages" does not exist
> [12-1] ERROR: relation "pgadmin_languages" does not exist
> [13-1] ERROR: syntax error at or near "." at character 196
> [14-1] ERROR: relation "pgadmin_sequences" does not exist
> [15-1] ERROR: relation "pgadmin_sequences" does not exist
> [16-1] ERROR: syntax error at or near "." at character 653
After further thought, what you've probably got here is a bunch of
pgadmin view definitions that are failing because they reference bits
of the system catalogs that changed between 7.1 and 7.4. If you want
to continue to use pgadmin, you'll need to get an updated version and
install whatever views it's using now (after dropping any that did
manage to get created).
regards, tom lane