From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Kaloyan Iliev Iliev <news1(at)faith(dot)digsys(dot)bg> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Problems with pg_restore |
Date: | 2004-12-20 16:03:49 |
Message-ID: | 41C6F7E5.5010004@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Barwick | 2004-12-20 16:09:04 | Re: PG8 final when |
Previous Message | Kaloyan Iliev Iliev | 2004-12-20 15:52:23 | Re: Problems with pg_restore |