Cannot use postgres version 16 in cron job!

hi i created cron job from blueprint yaml following Backup PostgreSQL to Amazon S3 | Render Docs
to backup my pg to s3

bludprint yaml: postgres-s3-backups/render.yaml at main · Weixuanf/postgres-s3-backups · GitHub

my pg version is 16, its hosted on render so i set my env var POSTGRES_VERSION as 16
But i got this error when building my cron job: #10 0.068 POSTGRES_VERSION must be one of 11, 12, 13, 14, 15
Can you support pg 16 backup? thank you!


#9 [4/6] COPY install-pg-dump.sh .
#9 DONE 0.0s
#10 [5/6] RUN "/scripts/install-pg-dump.sh"
#10 0.068 POSTGRES_VERSION must be one of 11, 12, 13, 14, 15
#10 ERROR: process "/bin/sh -c \"/scripts/install-pg-dump.sh\"" did not complete successfully: exit code: 1
------
 > [5/6] RUN "/scripts/install-pg-dump.sh":
0.068 POSTGRES_VERSION must be one of 11, 12, 13, 14, 15
------
Dockerfile:9
--------------------
   7 |     WORKDIR /scripts
   8 |     COPY install-pg-dump.sh .
   9 | >>> RUN "/scripts/install-pg-dump.sh"
  10 |     
  11 |     COPY backup.sh .
--------------------
error: failed to solve: process "/bin/sh -c \"/scripts/install-pg-dump.sh\"" did not complete successfully: exit code: 1
error: exit status 1

Hi there,

We have an open PR for this issue: https://github.com/render-examples/postgres-s3-backups/pull/8. Once this is merged please update your forked repo and have another go. Do note that we have switched the base image to Alpine Linux and you will need to set both the POSTGRES_VERSION and ALPINE_VERSION environment variables. The README will be updated to reflect this change.

Regards,

Keith
Render Support, UTC+10 :australia:

1 Like

thank you very much! this is very needed for me! thanks so much for your prompt response.
I really enjoy using Render for my project now! the ux is really good.

i’ll wait for it to be merged then!