On Tue, 8 Oct 2002, Elielson Fontanezi wrote:
> to identify Linux user which starts the shell script to avoid password
> prompt.
There's a virtually-undocmented environment variable: PGPASSWORD
PGPASSWORD="secret-password"
export PGPASSWORD
# Now pg_dump will not prompt for password.
pg_dump -U postgres ...
Make sure you only use this in a script which normal users cannot read,
and on a system which hides root-process environment variables from
being displayed by normal users (with ps).
--
David.