Re: Urgent: Restoring many schemas in a database

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 majordomo@postgresql.org



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/