pg_receivexlog or archive_command

From: Vikas Sharma <shavikas(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: pg_receivexlog or archive_command
Date: 2019-09-23 08:25:44
Message-ID: CAN6gwKwx865jv0fqc7SfwsG3utPhSoFF_tFaptcoDUW+T0uP8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Best wishes
Vikas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul McGarry 2019-09-23 08:32:44 How to get timezone offset in timestamp with time zone AT TIME ZONE output.
Previous Message Corey Taylor 2019-09-23 07:07:55 Re: postgres 9.6: insert into select finishes only in pgadmin not psql