On Saturday 29 November 2008, "Andrus" <kobruleht2@xxxxxx> wrote: > 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 ? Investigate the date command, shell scripting in general, the ncftp program (specifically its ncftpput command), and cron. If you're that unfamiliar with Linux, though, I would very strongly suggest not using Gentoo. -- Alan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
