pg_dump automatic - Mailing list pgsql-general

From Enrico Comini
Subject pg_dump automatic
Date
Msg-id PPEOLEBLEGFKDAOCDMLHEEOOHMAA.algobit@ALGOBIT.COM
Whole thread Raw
Responses Re: pg_dump automatic
List pgsql-general
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



pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: I was spoiled by the MySQL timestamp field
Next
From: Dennis Gearon
Date:
Subject: Re: ORDER BY 'criteria'