At 01:22 PM 6/5/2003 -0700, Jonathan Gardner wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Thursday 05 June 2003 04:56, David A. Leedom wrote: > 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. >
Don't use pg_restore. Use psql. Note that pg_dump dumps a bunch of SQL commands.
This is also a cheap way to "vacuum" the database:
# pg_dump <dbname> | gzip > dump.gz # dropdb <dbname> # createdb <dbname> # gunzip -c dump.gz > psql <dbname>
- -- Jonathan Gardner <[EMAIL PROTECTED]> (was [EMAIL PROTECTED]) Live Free, Use Linux! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE+36aSWgwF3QvpWNwRAveXAJ4qiMWs7bAsAQoQYmUb0j1bkYOrjwCgwVt6 Gkotl26Q7541ofhVDTP4lQk= =U7V7 -----END PGP SIGNATURE-----
--- Incoming 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
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 [EMAIL PROTECTED]
