Postgres Pro
Downloads
Home   >   mailing lists

Urgent: Restoring many schemas in a database - Mailing list pgsql-admin

From Stephen J. Thompson
Subject Urgent: Restoring many schemas in a database
Date
Msg-id 200306051149.32063.stephen@cass-ltd.co.uk
Whole thread Raw
Responses Re: Urgent: Restoring many schemas in a database  (<mallah@trade-india.com>)
Re: Urgent: Restoring many schemas in a database  (Oliver Elphick <olly@lfix.co.uk>)
Re: Urgent: Restoring many schemas in a database  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Urgent: Restoring many schemas in a database  (Bruno Wolff III <bruno@wolff.to>)
Re: Urgent: Restoring many schemas in a database  (Jonathan Gardner <jgardner@jonathangardner.net>)
Re: Urgent: Restoring many schemas in a database  (Jonathan Gardner <jgardner@jonathangardner.net>)
List pgsql-admin
Tree view 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello all,

I am trying to restore a 7.3 database with many schemas and schema users in
it. The issue I am having is that there are many \connect statements in the
backup file and it keeps asking me for a new password each time. Is there an
easier way than examining the file and carefully following the connect
statement orders and entering the correct password. (btw there are over 100
connect statements).

Thanks.


Stephen.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE+3yA7DAwPLUWQb6sRAn27AJ9TgcQ8BNqStKA6WKGpV3+De26m5wCgnHas
5jBZaAp/3NchLvRpof14emU=
=Z9On
-----END PGP SIGNATURE-----

pgsql-admin by date:

Previous
From: "David A. Leedom"
Date:
Subject: Backup and Restore
Next
From: Peter Childs
Date:
Subject: Re: interpret vacuum verbose output