Re: Backup and Restore

But I have blobs in my data so I am using -F c

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 <jgardner@jonathangardner.net>
>(was jgardn@alumni.washington.edu)
>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