Re: pgadmin III - database backup / restore

paul(dot)n(dot)shortis(at)mainroads(dot)qld(dot)gov(dot)au wrote:
>
>
>
>
> Sorry about that Andreas, I'm used to the Xitami list where I just reply to
> a message and it automatically goes to the list.
>
> When I run pg_dump with or without the -U switch to provide the db user
> name, I always get prompted for a password, then (providing the passsword
> was correct) the dump executes successfully.

Oh dear, I didn't notice that. I always tested on trusted connections.

>
> Since pg_dump doesn't have a switch to supply the password (it always
> appears to want the password interactively) I would guess that pgadmin
> would need to supply stdin to the spawned copy of pg_dump.

Will take me some time to fix.

Regards,
Andreas