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

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_checks" does not exist
Дата
Msg-id 03AF4E498C591348A42FC93DEA9661B889F81C@mail.vale-housing.co.uk
обсуждение исходный текст
Список pgadmin-support

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



В списке pgadmin-support по дате отправления:

Предыдущее
От: Chris Lee
Дата:
Сообщение: Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_ch ecks" does not exist
Следующее
От: "Stefan Donath"
Дата:
Сообщение: pgAdmin III and PSQL