Re: how do I do dump and restore without bugging with constraint? - Mailing list pgsql-general

From John R Pierce
Subject Re: how do I do dump and restore without bugging with constraint?
Date
Msg-id 4B836324.7090604@hogranch.com
Whole thread Raw
In response to how do I do dump and restore without bugging with constraint?  ("Net Tree Inc." <nettreeinc@gmail.com>)
Responses Re: how do I do dump and restore without bugging with constraint?  ("Net Tree Inc." <nettreeinc@gmail.com>)
List pgsql-general
Net Tree Inc. wrote:
> Hi all,
>
> I am dumping both schema and data from old database to new one. The
> new database schema is somehow contain slightly different schema then
> the old one. When I do restore it shown alot errors related with
> constraints. How can I dump and to restore from old to new without
> dealing with constraint and just forces data dump to where it suppose
> to belong?
>
>
>
>


if you're dumping the schema and the data, you should be restoring into
an empty database, not into an existing database.



pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: [ADMIN] how do I do dump and restore without bugging with constraint?
Next
From: Bruce Momjian
Date:
Subject: Re: COPY command character set