Re: Problems with pg_restore

Kaloyan Iliev Iliev wrote:
> Hi ,
>
> I have the following problem.
>
> DBVersion:  PostgreSQL 7.2.3 on i386-pc-bsdi4.0.1, compiled by GCC 2.7.2.1
>
> I have a dump of a database on two parts.
> Here are the dump commands:
>
> pg_dump  -s -S postgres "db_name" |gzip > "db_name.shema.sql"
> pg_dump -S postgres -a -Fc "db_name" > "db_name.data.dump"
>
> So restore twice the schema with the following command:
>
> psql -e "db_name" < "db_name.shema.sql"
> psql -e "db_name" < "db_name.shema.sql"
>
> I do it twice because some tables don't create from the first time.
[snip]
> Now I try to delete it in PG8.0.0 but :
> ALTER TABLE ONLY epay_requests_archive DROP COLUMN deleted RESTRICT;
> ERROR:  cannot drop inherited column "deleted"
>
> The problem is that I don't have another copy of this database so I must
> find a way to restore it.

If you've got two versions of PG, it's usually best to use the most
recent pg_dump - each version is smarter than the last, but is
backwards-compatible quite a way. Try dumping with the 8.0 version of
pg_dump.

--
   Richard Huxton
   Archonet Ltd