Re: shell script to SQL statement: `pg_dump | psql -U`

"filippo" <filippo2991@virgilio.it> writes:
> The problem with the current implementation is that sometime pd_dump
> and psql ask for password but I want to create the database copy
> without any user typing (it is a cron script).

Create a ~/.pgpass file for the user that runs the cron job.

            regards, tom lane