-----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). >
Put a .pgpass file in the home directory of the user. It should have a 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+36W3WgwF3QvpWNwRAnvkAJ4zcFGBMemqGRqYTRTdcPQTZqUvwACeMmIn Lgiq5VrDOowcpmdSbn5EtDU= =Ldm6 -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
