Re: Backup and Restore

This is a well known issue, you can change Postgress
version to 7.3.3 and the pg_dump on that version is
more smart.

Gaetano

----- Original Message -----
From: "David A. Leedom" <daleedom(at)hightowergroup(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Sent: Thursday, June 05, 2003 1:56 PM
Subject: [ADMIN] Backup and Restore

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

----------------------------------------------------------------------------
----

>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.483 / Virus Database: 279 - Release Date: 5/19/2003
>

----------------------------------------------------------------------------
----

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org