Upgrade version of PostgreSQL used by Publishing API

alphagov / govuk-docker

GOV.UK development environment using Docker 🐳

MIT License

82 stars 22 forks source link

Upgrade version of PostgreSQL used by Publishing API #794

Closed brucebolt closed 1 week ago

brucebolt commented 2 weeks ago

We were using an outdated image, which contained a version of pg_restore that was not compatible with the dumps of production data.

The error pg_restore: error: unsupported version (1.15) in file header is returned when trying to restore our current dumps.

Therefore upgrading the version of PostgreSQL image we are using to allow replication of real data.

brucebolt commented 1 week ago

I'm not sure it's the same version of Postgres, but it's definitely a version of pg_restore that is compatible with the version of pg_dump we're using.

At some point, AWS will force upgrade our Postgres instances anyway.