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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]