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 Wed, Jun 19, 2019 at 4:33 PM Rui DeSousa <rui@xxxxxxxxxxxxx> wrote:
> On Jun 19, 2019, at 5:23 PM, Ron <ronljohnsonjr@xxxxxxxxx> 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, LLC
Cell # 267-799-3182 # pavan.dba27 (Gtalk)
#! Pavan Kumar
-----------------------------------------------
Sr. Database Administrator..!
NEXT GENERATION PROFESSIONALS, LLC
Cell # 267-799-3182 # pavan.dba27 (Gtalk)
India # 9000459083
Take Risks; if you win, you will be very happy. If you lose you will be Wise
