Re: backup and archive postgresql data older than 6 months

From: Ian Barwick <ian(at)2ndquadrant(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: kaushalshriyan(at)gmail(dot)com
Subject: Re: backup and archive postgresql data older than 6 months
Date: 2015-08-26 11:09:03
Message-ID: 55DD9E4F.7040807@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vincent de Phily 2015-08-26 12:03:57 Re: PostgreSQL Developer Best Practices
Previous Message Kaushal Shriyan 2015-08-26 10:46:53 backup and archive postgresql data older than 6 months