Re: pg_dump automatic

Is your script running as postgres on your postgres data server ?

""Enrico Comini"" <algobit@algobit.com> wrote in message
news:PPEOLEBLEGFKDAOCDMLHEEOOHMAA.algobit@ALGOBIT.COM...
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org