Re: Why standby restores some WALs many times from archive?

2018-01-10 Thread Sergey Burladyan
{ if (!expectedTLEs) expectedTLEs = tles; return fd; } } Well, I think we'll be able to cache locally the last WAL file in restore_command if needed :-) -- Sergey Burladyan

Re: Why standby restores some WALs many times from archive?

2017-12-30 Thread Sergey Burladyan
Michael Paquier writes: > On Sat, Dec 30, 2017 at 04:30:07AM +0300, Sergey Burladyan wrote: > > We use this scripts: > > https://github.com/avito-tech/dba-utils/tree/master/pg_archive > > > > But I can reproduce problem with simple cp & mv: > > arch

Re: Why standby restores some WALs many times from archive?

2017-12-29 Thread Sergey Burladyan
2B pg_xlog/RECOVERYXLOG" LOG: restored log file "0001002B" from archive DEBUG: got WAL segment from archive DEBUG: executing restore command "cp /var/lib/postgresql/wals/0001002C pg_xlog/RECOVERYXLOG" LOG: restored log file "0001002C" from archive DEBUG: got WAL segment from archive -- Sergey Burladyan standby.log.bz2 Description: BZip2 compressed data pg-wal-arch-test.tar.bz2 Description: Unix tar archive