-----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 <[EMAIL PROTECTED]> (was [EMAIL PROTECTED]) Live Free, Use Linux! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+4QN5WgwF3QvpWNwRAuzdAJwJUYr/aabryj1ZyvfeLrgcMBJGGwCgk7FC itynkuB0XX3Y6VgqGzTayA8= =wdgM -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
