> The problem is that the dump contains \connect commands which require me
> to either authenticate or create *nix users and run ident - as far as I
> can tell. Ideally I'd like the super-user to be able to perform these
> connects silently - the initial authentication effectively happening at
> sudo time.
I suppose, using --use-set-session-authorization option in pg_dump command
must help. Refer the pg_dump manual page for more details.
regards,
bhuvaneswaran