-----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----- ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
