Re: pg_receivexlog or archive_command

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_receivexlog or archive_command
Date: 2019-09-23 08:55:39
Message-ID: 57a86418-1841-89e0-d53b-dad445972169@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2019-09-23 11:39:19 unable to drop index because it does not exists
Previous Message Francisco Olarte 2019-09-23 08:54:48 Re: How to represent a bi-directional list in db?