| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | "Net Tree Inc(dot)" <nettreeinc(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: how do I do dump and restore without bugging with constraint? |
| Date: | 2010-02-23 05:09:56 |
| Message-ID: | 4B836324.7090604@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Net Tree Inc. | 2010-02-23 06:39:11 | Re: how do I do dump and restore without bugging with constraint? |
| Previous Message | Kevin Grittner | 2010-02-23 05:02:42 | Re: how do I do dump and restore without bugging with constraint? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-02-23 05:17:45 | Re: COPY command character set |
| Previous Message | Kevin Grittner | 2010-02-23 05:02:42 | Re: how do I do dump and restore without bugging with constraint? |