From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Chris Lee" <Chrislee(at)centurycity(dot)com(dot)hk>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_checks" does not exist |
Date: | 2004-03-24 09:57:05 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B889F81C@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Donath | 2004-03-24 13:42:07 | pgAdmin III and PSQL |
Previous Message | Chris Lee | 2004-03-24 09:29:22 | Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_ch ecks" does not exist |