Search Postgresql Archives

pg_receivexlog or archive_command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: pg_receivexlog or archive_command
From: Vikas Sharma <shavikas@xxxxxxxxx>
Date: Mon, 23 Sep 2019 09:25:44 +0100

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: pg_receivexlog or archive_command
  - From: Stephen Frost
- Re: pg_receivexlog or archive_command
  - From: Peter Eisentraut
- Re: pg_receivexlog or archive_command
  - From: Andreas Kretschmer

Prev by Date: Re: postgres 9.6: insert into select finishes only in pgadmin not psql
Next by Date: How to get timezone offset in timestamp with time zone AT TIME ZONE output.
Previous by thread: Help: Postgres Replication issues with pacemaker
Next by thread: Re: pg_receivexlog or archive_command
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux