db backup script in gentoo

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: db backup script in gentoo
Date: 2008-11-29 17:34:48
Message-ID: ggrv2t$1q06$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2008-11-29 19:23:03 Re: db backup script in gentoo
Previous Message Robert Haas 2008-11-29 16:42:33 Re: why hash on the primary key?