Re: [ADMIN] pg_dump command inside shell scripts

2002-10-08 Thread David F. Skoll
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

[ADMIN] pg_dump command inside shell scripts

2002-10-08 Thread Elielson Fontanezi
Hi Folks! Again I need a help from you! I have develop a shell script (seen below) to do dump and vaccum automatically. Once pg_dump command prompts for password, I changed the $PGDATA/*hba.conf file to identify Linux user which starts the shell script to avoid password prompt. But n