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(at)postgresql(dot)org

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