Skip site navigation (1) Skip section navigation (2)

Re: db backup script in gentoo

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: db backup script in gentoo
Date: 2008-11-29 19:23:03
Message-ID: 200811291123.03904@hal.medialogik.com (view raw or flat)
Thread:
Lists: pgsql-general
On Saturday 29 November 2008, "Andrus" <kobruleht2(at)hot(dot)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

In response to

pgsql-general by date

Next:From: Uwe C. SchroederDate: 2008-11-29 19:39:26
Subject: Re: db backup script in gentoo
Previous:From: AndrusDate: 2008-11-29 17:34:48
Subject: db backup script in gentoo

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group