Re: Backup and Restore - Mailing list pgsql-admin

From Jonathan Gardner
Subject Re: Backup and Restore
Date
Msg-id 200306051322.43748.jgardner@jonathangardner.net
Whole thread Raw
In response to Backup and Restore  ("David A. Leedom" <daleedom@hightowergroup.com>)
List pgsql-admin
-----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-----

pgsql-admin by date:

Previous
From: "Vlad Efman"
Date:
Subject: unsubscribe
Next
From: Robert Treat
Date:
Subject: Re: Urgent Help Needed !!!!!!!