Re: pg_receivexlog or archive_command

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Vikas Sharma <shavikas(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_receivexlog or archive_command
Date: 2019-09-23 18:31:54
Message-ID: 500e2a7e-8c40-32bb-432b-8f728daf4e5a@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2019-09-23 10:25, Vikas Sharma wrote:
> I am wondering which one is the best way to archive the xlogs for Backup
> and Recovery - pg_receivexlog or archive_command.

I recommend using pg_receivexlog. It has two important advantages over
archive_command: 1) You can have multiple instances of pg_receivexlog
running and copying things to different places. This is complicated to
do correctly with archive_command. 2) pg_receivexlog will fsync the
files it writes. This is also complicated to do correctly with
archive_command.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Snaidero 2019-09-23 18:40:00 Error during analyze after upgrade from 10.10 -> 11.4
Previous Message Laurenz Albe 2019-09-23 18:16:28 Re: Autovacuum lock conflict