Hello Rui,
yes those are committed transaction.
I have tested two cases
1. complete lost. (means complete data directory, pg_wal direcoty)
2. lost few directories (deleted few directories , except pg_wal).
both cases I do see latest data in the current wal is lost.
when I check the recovery process , wal archives are copying from pgbackrest repository to pg_wal directory. however pgbackrest tool is not copying current wal log at all. it is only copying archived wal's/
is there any way to copy current wal log with pgbackrest tool?
> On Jun 19, 2019, at 5:23 PM, Ron <ronljohnsonjr@gmail.com> wrote:
>
> Set the checkpoint timeout to something closer to what you want.
>
>
Checkpoint does not matter.
You shouldn’t loose committed transactions. Was the transaction committed? Do you have all the WALs?
--
Regards,
#! Pavan Kumar
-----------------------------------------------
Sr. Database Administrator..!NEXT GENERATION PROFESSIONALS, LLCCell # 267-799-3182 # pavan.dba27 (Gtalk) India # 9000459083Take Risks; if you win, you will be very happy. If you lose you will be Wise