> I want to program pg_dump in crontab but with authentification of user
> pg_dump prompt a user name and password.
> how can i backup my database automatic (one backup for a day).
> pg_version :7.0
This is my backup script: (1 line)
su -c "PGPASSWORD=;export
PGPASSWORD;pg_dumpall>/var/lib/pgsql/postgres_backup" postgres
PGPASSWORD is your postgreSQL administrator password.
I use pg_dumpall to dump all databases in one time.