search

fly-apps / postgres-flex

Postgres HA setup using repmgr
67 stars 32 forks source link

Update Docker tag for postgres timescale variant to v16 #215

Closed smorimoto closed 3 days ago

smorimoto commented 7 months ago

Support for pg16 is expected in 2.13: https://github.com/timescale/timescaledb/releases/tag/2.12.0 https://github.com/timescale/timescaledb/milestone/77

smorimoto commented 7 months ago

Okay, the timescale is ready to go!

smorimoto commented 5 months ago

Ref: https://packagecloud.io/timescale/timescaledb/packages/debian/bookworm/timescaledb-2-2.13.1-postgresql-16_2.13.1~debian12_amd64.deb

JAForbes commented 5 months ago

hey @smorimoto, how are you testing this? I tried creating a new pg, pushing the image to the app's registry, and running fly image update, but I can't seem to get a healthy instance. Wondering if I'm missing a crucial step.

I keep hitting issues with repmgr not being able to connect because of a version mismatch.

[NOTICE] repmgrd (repmgrd 5.4.1) starting up
[INFO] connecting to database "host=fdaa:0:78c0:a7b:233:51f3:5a9f:2 port=5433 user=repmgr dbname=repmgr connect_timeout=5"
[ERROR] an older version of the "repmgr" extension is installed
[DETAIL] extension version 5.3 is installed but newer version 5.4 is available
[HINT] verify the repmgr installation is updated properly before continuing
JAForbes commented 5 months ago

hey @smorimoto, how are you testing this? I tried creating a new pg, pushing the image to the app's registry, and running fly image update, but I can't seem to get a healthy instance. Wondering if I'm missing a crucial step.

I keep hitting issues with repmgr not being able to connect because of a version mismatch.

[NOTICE] repmgrd (repmgrd 5.4.1) starting up
[INFO] connecting to database "host=fdaa:0:78c0:a7b:233:51f3:5a9f:2 port=5433 user=repmgr dbname=repmgr connect_timeout=5"
[ERROR] an older version of the "repmgr" extension is installed
[DETAIL] extension version 5.3 is installed but newer version 5.4 is available
[HINT] verify the repmgr installation is updated properly before continuing

Update: It works if I push to docker hub and create a fresh postgres and avoid image update.

davissp14 commented 4 months ago

Repmgr 5.4.1 is getting installed automatically with the new image build. I updated the base image to pin the repmgr version, but we may need to migrate to 5.4.1 for PG 16. The latest version of repmgr should work fine with PG15, but the upgrade path needs more testing.

JAForbes commented 4 months ago

What would the very rough ETA be on the release given it needs more testing? Just on the fence about using the new timescale syntax (not currently supported with fly's TS version) for some work or holding off.

smorimoto commented 3 months ago

Rebased to latest master.

davissp14 commented 3 days ago

Closing in favor of: https://github.com/fly-apps/postgres-flex/pull/233