search

shayonj / pg_easy_replicate

Easily setup logical replication and switchover to new database with minimal downtime
MIT License
948 stars 18 forks source link

Update pg_dump version to latest #191

Open joetynan opened 1 week ago

joetynan commented 1 week ago

Not sure if this is a reversion or not, but just today I noticed when I try to execute bootstrap on postgres servers running 16.4, I get a pg_dump version mismatch error. Looks like currently the container is using pg_dump 15.9.

joetynan commented 1 week ago

doh! should have been more specific- this is when using the docker image that I get this error. The "fix" I had was to start an instance of the image and console in, then uninstall postgres-client-15 and install postgres-client-16.

shayonj commented 1 week ago

ah! yes, so this is an issue for sure. Because the docker just installs it from the apk repo. Its hard to solve for I guess, since users can be working with different PG versions. Will have to have a think.

joetynan commented 1 week ago

one thing that you could try is to update the dockerfile with a couple commands - basically uninstall the old postgres-client-15, and then update/add repo and then install the latest version of the client tools. Just an idea.

shayonj commented 1 week ago

yeah, i think thats basically what we might need to do. Because newer clients I think can work with older pg versions (?). Need to check