Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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.


pgadmin-support by date

Next:From: Stefan DonathDate: 2004-03-24 13:42:07
Subject: pgAdmin III and PSQL
Previous:From: Chris LeeDate: 2004-03-24 09:29:22
Subject: Migration Btw Rel - 7.1.2 to 7.4.2 - ERROR: relation "pgadmin_checks" does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group