Edit on GitHub
PostgreSQL Error: Current Transaction ID Has Moved Backwardslink
Questionlink
The following error message appears:
Current transaction ID has moved backwards.
Environmentlink
Connector: PostgreSQL
Answerlink
A historical re-sync is required.
Causelink
When the transaction ID has moved backward, this usually means that we have been connected to a different database instance. This could be from master to replica, from one replica to another, or if a database has moved to a new server.
We will be indefinitely waiting for the transaction ID to catch up. As a result, a re-sync is required.