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

Поиск
Список
Период
Сортировка

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

От
"Dave Page"
Дата:

> -----Original Message-----
> From: Chris Lee [mailto:Chrislee@centurycity.com.hk]
> Sent: 24 March 2004 09:29
> To: 'pgadmin-support@postgresql.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.