Re: Urgent: Restoring many schemas in a database

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 05 June 2003 03:49, Stephen J. Thompson wrote:
> 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).
>

Try ~/.pgpass with one line:
*:*:*:<username>:<password>

- --
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+4QN5WgwF3QvpWNwRAuzdAJwJUYr/aabryj1ZyvfeLrgcMBJGGwCgk7FC
itynkuB0XX3Y6VgqGzTayA8=
=wdgM
-----END PGP SIGNATURE-----