Update pg_dump in cron job from version 11 to 14

1

Hi, I’ve got a Cron job that creates a backup of my render postgres database every hour with pg_dump and uploads it to AWS S3. It used to work fine with postgres version 11 because the pg_dump that is installed in the environment where render Cron jobs run is also version 11. I updated my database to version 14 and now I get this error:

pg_dump: server version: 14.0; pg_dump version: 11.12 (Debian 11.12-0+deb10u1)
pg_dump: aborting because of server version mismatch

How can I update pg_dump to support version 14? It looks like I don’t have the permissions to do a regular app-get install.

4

Hey @tom - we’re looking into this on our end. I’ll follow up here when we have an update to share!

5

Hi @tom , I believe we’ve followed up with you privately on this, but for anyone else who comes across this: We’ve rolled out an update to the cron job environments to work with PostgreSQL 14, so everything should now be good!

2 Likes