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

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$ (view raw, whole thread or download thread mbox)
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"

I have few experience in Linux. How to convert this to Gentoo Linux ?



pgsql-general by date

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

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