backup and archive postgresql data older than 6 months
Kaushal Shriyan <kaushalshriyan@gmail.com>
From: Kaushal Shriyan <kaushalshriyan@gmail.com>
To: pgsql-general@postgresql.org
Date: 2015-08-26T10:46:53Z
Lists: pgsql-general
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. Any help will be highly appreciable. Regards, Kaushal