* Christoph Moench-Tegeder (c...@burggraben.net) wrote:
> ## Stephen Frost (sfr...@snowman.net):
>
> > 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.
>
>
## Ron Johnson (ron.l.john...@cox.net):
> > 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.
>
> And if logging to stderr?
In that case your original approach could
## Stephen Frost (sfr...@snowman.net):
> 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.
That risk already exists when using rsync/scp/scp/... and should be
On 08/28/2017 08:22 AM, Stephen Frost wrote:
* Christoph Moench-Tegeder (c...@burggraben.net) wrote:
## Ron Johnson (ron.l.john...@cox.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
* Christoph Moench-Tegeder (c...@burggraben.net) wrote:
> ## Ron Johnson (ron.l.john...@cox.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
On 08/28/2017 06:06 AM, Christoph Moench-Tegeder wrote:
## Ron Johnson (ron.l.john...@cox.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
## Ron Johnson (ron.l.john...@cox.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
Hi,
How is this done in v8.4? (I tried adding "date; rsync ..." but pg didn't
like that *at all*.)
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general