> 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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
