Re: supply user/pass to pg_dump noninteractive - Mailing list pgsql-general

Peter Pilsl writes:

> for backup-purposes I'd like to run pg_dump in a script. Is there any
> easy way to provide the user/pass-information noninteractive or do I
> need to change the source/provide a wrapper ?

Try one of

export PGPASSWORD=foo
pg_dump

or

(echo "username"; echo "password") | pg_dump

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter