search

BCDevOps / backup-container

A simple container for a simple backup strategy.
Apache License 2.0
39 stars 56 forks source link

Postgresql 15 #128

Closed thegentlemanphysicist closed 4 months ago

thegentlemanphysicist commented 4 months ago

A short PR to implement the postgres 15 image, and document the known issue with the patroni restoration process.

WadeBarnes commented 4 months ago

Thanks for this @thegentlemanphysicist. Have you had a chance to test this out much yet?

I'll try to get some testing in on some older databases as soon as I can.

thegentlemanphysicist commented 4 months ago

Thanks for this @thegentlemanphysicist. Have you had a chance to test this out much yet?

I'll try to get some testing in on some older databases as soon as I can.

I've run it in our old sandbox environment and it seems to have worked as expected, I was going to repeat today to see if I can use the container to upgrade our postgres instance from 13 to 15.

thegentlemanphysicist commented 4 months ago

I was able to use the database container with fedora 15 to upgrade my patroni db from using postgres 13 to 15. The commands still raise some errors about metric helper's missing, however that's mostly internal patroni tables.