Postgres Pro
Downloads
Home   >   mailing lists

Re: archive_command options? - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: archive_command options?
Date
Msg-id 38b0f300-4c24-54f9-d5de-683508541c47@2ndquadrant.com
Whole thread Raw
In response to archive_command options?  (LEROY TENNISON <leroy_tennison@prodigy.net>)
List pgsql-admin
Tree view 
On 2019-04-03 22:16, LEROY TENNISON wrote:
> Postgresql documentation lists the following as an archive command for
> log shipping:
> 
> archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p
> /mnt/server/archivedir/%f'
> 
> The problem is that it is very fragile.

A more robust alternative is to use pg_receivewal.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-admin by date:

Previous
From: Keith Fiske
Date:
Subject: Re: archive_command options?
Next
From: Mark Steben
Date:
Subject: Re: Long running query in new production, not so long in old