Re: Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_checks" does not exist

> -----Original Message-----
> From: Chris Lee [mailto:Chrislee(at)centurycity(dot)com(dot)hk]
> Sent: 24 March 2004 09:29
> To: 'pgadmin-support(at)postgresql(dot)org'
> Subject: [pgadmin-support] Migration Btw Rel - 7.1.2 to 7.4.2
> - ERROR: relation "pgadmin_checks" does not exist
>
> Hi,
>
> * This question already ask at pgsql-general mailinglist *
>
> 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:

Hi Chris,

pgAdmin I (which is *really* old now) used to create some of the objects
mentioned. There are just normal tables/views etc. though, so if your
dump is failing to reload then it is a PostgreSQL issue.

Is it a large dump file? Perhaps if you restored it with the -e option
to psql it will show the queries that are causing the error to occur?

Regards, Dave.