Postgresql Transaction Log backup/restore

Users
1

Dear all!
As some of you know, we are using the JDBC plugin to store our transactions in Postgresql here.

We wanted to ask if there is a consolidate backup/restore strategy (or scripts?). The quirk we see, but there might be more, is the transaction offset sequence to replicate on restore.

Any other hint?

Thank you in advance!

1 Like
2

Hey @arichiardi are you writing both the tx-log and docs to a single table? Assuming so then all documents are guaranteed to have been written prior the last tx-id and a pg_dump should be sufficient. The latest-submitted-tx tx-id should be reliable and consistent with what you’d expect once restored.