| From: | "Stephen J(dot) Thompson" <stephen(at)cass-ltd(dot)co(dot)uk> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Urgent: Restoring many schemas in a database |
| Date: | 2003-06-05 10:49:25 |
| Message-ID: | 200306051149.32063.stephen@cass-ltd.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David A. Leedom | 2003-06-05 11:56:26 | Backup and Restore |
| Previous Message | Peter Childs | 2003-06-05 08:54:49 | Re: interpret vacuum verbose output |