backup and archive postgresql data older than 6 months

[Kaushal Shriyan <kaushalshriyan@xxxxxxxxx>]

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