search

borgmatic-collective / docker-borgmatic

Borgmatic in Docker
GNU General Public License v3.0
313 stars 88 forks source link

pg_dump does not support postgresql 16. #313

Closed tetricky closed 2 months ago

tetricky commented 2 months ago

I've hit a roadblock with an issue - dumping postgresql 16 databases.

pg_dump: error: aborting because of server version mismatch
pg_dump: detail: server version: 16.1; pg_dump version: 15.6

I appreciate that this is an upstream issue. postgresql-client16 is not supported in the container

# apk search postgresql-client
postgresql-bdr-client-9.4.14_p1-r15
postgresql12-client-12.18-r0
postgresql13-client-13.14-r0
postgresql14-client-14.11-r0
postgresql15-client-15.6-r0

This is an inconvenience, because the handling of database dumps within borgmatic is a big advantage that cuts out a lot of other steps.

Is there any possible resolution?

This is my first serious attempt at using borgmatic in a container, and it's a very nice addition to an excellent tool.

tetricky commented 2 months ago

I've made a quick and dirty bash script to do database dumps from the postgresql container. Which provides a short term solution of sorts. Would still prefer postgresql16-client to be supported in the container.