From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Logging the fact that a log was shipped |
Date: | 2017-08-28 13:39:29 |
Message-ID: | 0ecd6d4d-0194-4c7a-2712-0e689bbc976e@cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 08/28/2017 08:22 AM, Stephen Frost wrote:
> * Christoph Moench-Tegeder (cmt(at)burggraben(dot)net) wrote:
>> ## Ron Johnson (ron(dot)l(dot)johnson(at)cox(dot)net):
>>
>>> How is this done in v8.4? (I tried adding "date; rsync ..." but pg
>>> didn't like that *at all*.)
>> There's a DEBUG1-level log message on successful archive_command
>> completion - that would give you a lot of other low-prio log
>> messages wich you probably don't care about.
>> I'd put a wrapper around your rsync (a short shell script
>> would be sufficient) in the lines of rsync ... && logger "done",
>> that way you'd get the information via syslog.
>> On the other hand, do you really need the details about each WAL
>> segment? Since 9.4 there's pg_stat_wal_archiver... You're really
>> making your job harder than it needs to be with that ancient
>> PostgreSQL...
> Worse, such scripts run the serious risk of losing WAL if a crash
> happens because nothing is ensuring that the WAL has been sync'd to disk
> before returning from the archive_command.
>
> Most of the existing tools for dealing with WAL archival (pgbackrest,
> barman and WAL-E, at least) already log successful and unsuccessful
> archive command runs. I'm pretty sure barman supports back to 8.4 and I
> know pgbackrest does.
Thanks for the info on pgbackrest.
--
World Peace Through Nuclear Pacification
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Moench-Tegeder | 2017-08-28 15:06:43 | Re: Logging the fact that a log was shipped |
Previous Message | Dave Cramer | 2017-08-28 13:30:30 | Re: jdbc driver vis Release 10 |