Re: backup and archive postgresql data older than 6 months

On Wed, 26 Aug 2015 10:46:53 +0000
Kaushal Shriyan <kaushalshriyan@gmail.com> wrote:

> Hi,
> 
> Are there scripts which takes backup of postgresql database and archive
> data older than 6 months and push it to a remote server using scp or rsync
> method and purge/clean the local data on the hard disk at the same time
> meaning at any given time we have only six months of postgresql data on the
> postgresql database server.

What system are you on?

On linux, you can use log_rotate to rotate your backups; just add a file to /etc/logrotate.d. Here is what I use to keep a weekly backup over one year:

/var/backups/marica/marica.gz {
	weekly
	missingok
	rotate 52
	notifempty
}

And here is a naive bash script to send a dump file to a remote server; it's launched by cron:

http://pastebin.com/Xg4wXdjy



-- 
					Salutations, Vincent Veyron 

https://legalcase.libremen.com/ 
Legal case, contract and insurance claim management software