Suggest me best Postgresql14 Backup tool like MySQL Xtrabackup

PostgreSQL
1

Hi Folks,

Suggest me best Postgresql14 Backup tool like MySQL Xtrabackup for full and incremental backups.

1 Like
2

Hi Naresh!

We have this very well documented in the blogs and online documentation pages. Take a look at the following links, and see if they have the answers you need :slight_smile: If you need incremental backups as a hard requirement, check pgBackRest first.

1 Like
3

Hi @Naresh9999
I would add that we have our Percona PostgreSQL distribution which contains the bunch of components and pgBackrest is among them. Please see: Percona Distribution for PostgreSQL

1 Like
4

Hi @Agustin_G and @Evgeniy_Patlan

Thank you so much for the suggestions. I am unable figure out how can we proceed the backups like xtrabackup and binary logs how we are doing in MySQL.
How can we set the automatic retention policy for the pg_xlog and archive logs in Postgresql 14?

1 Like