@@ -36,7 +36,9 @@ GOOS := $(shell go env GOOS)
36
36
GOARCH :=$(shell go env GOARCH)
37
37
GOOS_BIN_EXT :=$(if $(filter windows,$(GOOS ) ) ,.exe,)
38
38
VERSION :=$(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 )
40
42
41
43
# Use the highest ZSTD compression level in CI.
42
44
ifdef CI
@@ -949,12 +951,12 @@ test-postgres-docker:
949
951
docker rm -f test-postgres-docker-${POSTGRES_VERSION} || true
950
952
951
953
# 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 } || {
953
955
retries=2
954
956
for try in $(seq 1 ${retries}); do
955
957
echo "Failed to pull image, retrying (${try}/${retries})..."
956
958
sleep 1
957
- if docker pullgcr.io/coder-dev-1/postgres:${POSTGRES_VERSION }; then
959
+ if docker pull${POSTGRES_IMAGE }; then
958
960
break
959
961
fi
960
962
done
@@ -982,7 +984,7 @@ test-postgres-docker:
982
984
--restart no \
983
985
--detach \
984
986
--memory 16GB \
985
- gcr.io/coder-dev-1/postgres:${POSTGRES_VERSION } \
987
+ ${POSTGRES_IMAGE } \
986
988
-c shared_buffers=2GB \
987
989
-c effective_cache_size=1GB \
988
990
-c work_mem=8MB \