Am 23.09.19 um 10:25 schrieb Vikas Sharma:
Hi,I am wondering which one is the best way to archive the xlogs for Backup and Recovery - pg_receivexlog or archive_command.pg_receivexlog seems best suited because the copied/archived file is streamed as it is being written to in xlog while archive_command only copies when the WAL is fully written to.
you can use both of them, and you should consider "Barman". Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com