How to create automated backup script in Gentoo which in every night 3:00 PM
backups one database and sends backup
with ftp using unique file name?
In windows I can use scheduler and script
set FILENAME=%DATE:~8,4%%DATE:~5,2%%DATE:~2,2%MyDbBackup
pg_dump -Z6 -b -v -f "%FILENAME%.backup" -F c -h localhost -U postgres mydb
ftp -send -u username -p password "%FILENAME%.backup" ftp.backupserver.com
I have few experience in Linux. How to convert this to Gentoo Linux ?
Andtus
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
