Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_receivexlog or archive_command - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: pg_receivexlog or archive_command
Date
Msg-id 57a86418-1841-89e0-d53b-dad445972169@a-kretschmer.de
Whole thread Raw
In response to pg_receivexlog or archive_command  (Vikas Sharma <shavikas@gmail.com>)
Responses Re: pg_receivexlog or archive_command
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: How to represent a bi-directional list in db?
Next
From: Luca Ferrari
Date:
Subject: unable to drop index because it does not exists