@@ -36,7 +36,9 @@ GOOS := $(shell go env GOOS)
3636GOARCH :=$(shell go env GOARCH)
3737GOOS_BIN_EXT :=$(if $(filter windows,$(GOOS ) ) ,.exe,)
3838VERSION :=$(shell ./scripts/version.sh)
39- POSTGRES_VERSION ?= 16
39+
40+ POSTGRES_VERSION ?= 17
41+ POSTGRES_IMAGE ?= us-docker.pkg.dev/coder-v2-images-public/public/postgres:$(POSTGRES_VERSION )
4042
4143# Use the highest ZSTD compression level in CI.
4244ifdef CI
@@ -949,12 +951,12 @@ test-postgres-docker:
949951docker rm -f test-postgres-docker-${POSTGRES_VERSION} || true
950952
951953# Try pulling up to three times to avoid CI flakes.
952- docker pullgcr.io/coder-dev-1/postgres:${POSTGRES_VERSION } || {
954+ docker pull${POSTGRES_IMAGE } || {
953955retries=2
954956for try in $(seq 1 ${retries}); do
955957echo "Failed to pull image, retrying (${try}/${retries})..."
956958sleep 1
957- if docker pullgcr.io/coder-dev-1/postgres:${POSTGRES_VERSION }; then
959+ if docker pull${POSTGRES_IMAGE }; then
958960break
959961fi
960962done
@@ -982,7 +984,7 @@ test-postgres-docker:
982984--restart no \
983985--detach \
984986--memory 16GB \
985- gcr.io/coder-dev-1/postgres:${POSTGRES_VERSION } \
987+ ${POSTGRES_IMAGE } \
986988-c shared_buffers=2GB \
987989-c effective_cache_size=1GB \
988990-c work_mem=8MB \