Postgres Pro
Downloads
Home   >   mailing lists

pg_receivexlog or archive_command - Mailing list pgsql-general

From Vikas Sharma
Subject pg_receivexlog or archive_command
Date
Msg-id CAN6gwKwx865jv0fqc7SfwsG3utPhSoFF_tFaptcoDUW+T0uP8w@mail.gmail.com
Whole thread Raw
Responses Re: pg_receivexlog or archive_command
Re: pg_receivexlog or archive_command
Re: pg_receivexlog or archive_command
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Corey Taylor
Date:
Subject: Re: postgres 9.6: insert into select finishes only in pgadmin not psql
Next
From: Paul McGarry
Date:
Subject: How to get timezone offset in timestamp with time zone AT TIME ZONE output.