| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
|---|---|
| To: | Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> |
| Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Dumping/Restoring with constraints? |
| Date: | 2008-08-27 20:42:18 |
| Message-ID: | 48B5BC2A.5070104@wildenhain.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Hi,
Phoenix Kiula wrote:
> Hello. I have a database dump. With data and schema, which includes
> all the constraints and rules. But it seems the pg_dumpall command
> does not copy data in such a way that foreign keys are satisfied upon
> restoring. Because tables are inter-related, importing them keep
> giving errors and eventually no data is imported. Neither pg_dumpall
> nor pg_restore seems to have a "without constraints" or "delay
> constraints check" type command. What am I missing? Thanks for any
> advice.
Apart from disabling triggers temporarely, if you have enough
space in xlog, you could try to add BEGIN work; to the start
of the restore SQL and COMMIT; a the end.
Regards
Tino
| From | Date | Subject | |
|---|---|---|---|
| Next Message | windsurferdrew-pg | 2008-08-27 20:49:13 | Re: WAL files during a backup |
| Previous Message | steve | 2008-08-27 20:36:24 | Re: WAL files during a backup |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-08-27 20:54:09 | Re: Restoring a database from a file system snapshot |
| Previous Message | William Garrison | 2008-08-27 20:32:46 | Re: Restoring a database from a file system snapshot |