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

-----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