Re: archive_command options?

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: LEROY TENNISON <leroy_tennison(at)prodigy(dot)net>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: archive_command options?
Date: 2019-04-04 21:14:16
Message-ID: 38b0f300-4c24-54f9-d5de-683508541c47@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Steben 2019-04-05 15:23:29 Re: Long running query in new production, not so long in old
Previous Message Keith Fiske 2019-04-04 13:27:02 Re: archive_command options?