Hey guys, as I wrote in this post [image] Supported postgresql versions Installation Hi, checked the dump being made in backup file: It includes this on top SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transacti…

You might need something like this: - exec: cd: /var/www/discourse cmd: - apt-get update && apt-get remove -y postgresql-client-15 && apt-get install -y postgresql-client-16 db:migrate'" I haven’t tested that yet, but something like it worked a few weeks ago with 13 instead …

PostGres 17 statement in backups is blocking restore mechanism

Support

Falco (Falco) February 3, 2025, 2:41pm 2

Was your backup taken from a PostgreSQL 17 instance?

Topic		Replies	Views
Timeout when restoring a backup Self-hosting	2	881	December 16, 2020
Backups fail with Postgres 16 database (and all PG>13) Support	7	700	June 14, 2025
Supported postgresql versions Self-hosting	17	3214	March 2, 2025
Trouble with restore: "invalid command \restrict" Support	4	805	December 28, 2025
Restoring backup fails due to Postgres version mismatch Self-hosting	7	3316	February 14, 2019

PostGres 17 statement in backups is blocking restore mechanism

Related topics