I have a backup of a database from 8.2.x and I am trying to restore it
into 9.0.x
In 8.2.x I used the citext data type from pgfoundry (before it was part
of contrib) and it was put in the pg_catalog.
In 9.0 I am using the citext data type in contrib and it put it into the
public schema.
Postgresql 8.0.3
Windows XP with SP2
C:\Program Files\PostgreSQL\8.0\bin>pg_restore --dbname=smedb --verbose
--ignore
-version --host=localhost --username=postgres "c:\backup2005-08-08 10
.47.06"
when it was restoring data of one big table,it returned error msg like
[custom archive] can not read
[EMAIL PROTECTED] wrote:
> pg_dumpall > backup
> from 7.4 trying: pg_restore backup
> results in postgres' [Archiver]s suspicion that "backup"
> was not a valid archive.
What you backup by pg_dumpall is to be restored using psql, not
pg_restore. Read the man pages of pg_dump and pg_dumpall to co
Hi,
from 7.3 I created a backup by:
pg_dumpall > backup
from 7.4 trying: pg_restore backup
results in postgres' [Archiver]s suspicion that "backup"
was not a valid archive.
Where to look?
TIA Erwin
---(end of broadcast)---
TIP 4: Don't 'kill
