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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general