Re: backup and archive postgresql data older than 6 months

On 15/08/26 19:46, Kaushal Shriyan 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.

Have you looked at Barman ( http://www.pgbarman.org/ )?


Regards

Ian Barwick

-- 
 Ian Barwick                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, RemoteDBA, Training & Services