New image with existing tag 0.8.0 broke syncing

[aas47]

Hi,

First off, thank you for this amazing project — really appreciate all the effort you’ve put into it.

I wanted to report an issue we encountered recently. With the latest update to the v0.8.0 image tag, our pipeline sync started failing on older PostgreSQL versions (e.g., 14.15) with the following error:

pg_restore: connecting to database for restore
pg_restore: while INITIALIZING:
pg_restore: error: could not execute query: ERROR:  unrecognized configuration parameter "transaction_timeout"
Command was: SET transaction_timeout = 0;

We've resolved this by pinning the image to a previous digest:

docker.io/ankane/pgsync@sha256:e417bbecb03e15014aea86f4fb1283651f69d9c31ba9b83e614a3ad13fc41ce6

This version, built ~13 months ago, works as expected with our current PostgreSQL version.

For future releases, it would be helpful if updates could be published under a new tag instead of reusing an existing one. This would avoid unexpected breaking changes for users relying on pinned tags.

Thanks again for your work!

[aas47]

appreciate the quick fix on this!