Hi, have you considered the option of putting "trust" as auhentication in pg_hba.conf already.
other option is to user .pgpass file but i am not sure of the exact details regds mallah. > -----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----- > > > ---------------------------(end of broadcast)--------------------------- TIP 1: > subscribe and > unsubscribe commands go to [EMAIL PROTECTED] ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
