| From: | "David A(dot) Leedom" <daleedom(at)hightowergroup(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Backup and Restore |
| Date: | 2003-06-05 11:56:26 |
| Message-ID: | 5.2.0.9.0.20030605075052.028d9888@mail.hightowergroup.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I am using 7.2.x. When I run pg_dump on a database the objects are not
loaded in the correct dependency order.
Soooo.... when I run pg_restore it fails because objects that are needed
have not been restored yet (ie. trieds to restore a view that points to a
table that has not yet been restored). I then monkey around with the Table
of Contents (TOC) and am able to get the restore to work.
In the middle of a disaster I don't want to have to mess to the TOC.
What are others doing who are running into this situation.
Thanks,
Dave Leedom
The Hightower Group, Inc.
Information Technology Consulting
165 West Airport Road/Lititz, PA 17543
V:717-560-4002, 877-560-4002 x: 114
F:717-560-2825
www.hightowergroup.com
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/plain | 168 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mendola Gaetano | 2003-06-05 13:53:49 | Re: Backup and Restore |
| Previous Message | Stephen J. Thompson | 2003-06-05 10:49:25 | Urgent: Restoring many schemas in a database |