Thread: Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_ch ecks" does not exist
Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_ch ecks" does not exist
From
Chris Lee
Date:
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
Re: Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_ch ecks" does not exist
From
Tom Lane
Date:
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
Re: Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_ch ecks" does not exist
From
Tom Lane
Date:
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