Oa Wed, Dec 11, 2002 at 05:21:29PM +0100, zfgao(at)yahoo(dot)com wrote:
>
> Hi,
>
> I am trying to write some code to do automatic backup
> for PgSQL with pg_dump tool. For safty reason, I still
> want the password protection.
>
> 1. I tried to use script:
> echo "password" | pg_dump -U ....
> 2. I tried to use Java process, OutputStream.
>
> But pg_dump force password prompt. I don't find a way
> to give pg_dump with code. Does anyone have an idea?
>
This is what Don Libes invented expect for.
Cheers,
Han Holl