Dear friends,
my problem is to make automatic dump of a database.
I have a .backup.sh file for dump containing:
#! bin/sh
pg_dump -U user database > dump.txt
I have a password on the database, so when the file is executed it prompt
for the password.
I try :
pg_dump < passfile -U user database > dump.txt
pg_dump -U user database < -passfile > dump.txt
but is the same.
How I have to do ? THANKS
Enrico