Re: db backup script in gentoo - Mailing list pgsql-general

From Alan Hodgson
Subject Re: db backup script in gentoo
Date
Msg-id 200811291123.03904@hal.medialogik.com
Whole thread Raw
In response to db backup script in gentoo  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
On Saturday 29 November 2008, "Andrus" <kobruleht2@hot.ee> 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

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: db backup script in gentoo
Next
From: "Uwe C. Schroeder"
Date:
Subject: Re: db backup script in gentoo