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(at)jonathangardner(dot)net>
>(was jgardn(at)alumni(dot)washington(dot)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