Обсуждение: Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_ch ecks" does not exist

Hi,

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
.
.
Repeated
.


Do anyone know what does it mean? Is it related to pgadmin program?

Regards,
Chris Lee

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
> [ etc ]

Are you *certain* you used the 7.4 dump program to dump from the 7.1
server?  All these errors look like version incompatibilities ...

            regards, tom lane

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