On Fri, 10 Sep 2004, Tom Lane wrote:
> Hmm. This is still broken in CVS tip, but I think the correct solution
> is just to replace "\connect db user" with "\connect db" everywhere.
> This will retain the starting real user authentication throughout the
> restore process. We have completely abandoned use of \connect to change
> authorization, and this seems just an unintentional hangover from the
> old way.
Attached is a backport of your CVS commit to 7.4.5 it seems to work fine
here after some testing.