Re: Urgent: Restoring many schemas in a database

"Stephen J. Thompson" <stephen(at)cass-ltd(dot)co(dot)uk> writes:
> 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).

Use a non-password-based authentication method (TRUST even, if you are
the only person on the machine). Or if you can re-dump, use -X
use-set-session-authorization (I'm really not sure why we haven't made
this the default...)

regards, tom lane