PostGres 17 statement in backups is blocking restore mechanism

Support
1

Hey guys,

as I wrote in this post

It seems, that a statement which has been added in PostGre 17

SET transaction_timeout = 0

is being used, and that brakes the restore ability.

Any hints ?

Thanks and Cheers,

Wurzelseppi

2

Was your backup taken from a PostgreSQL 17 instance?

3

Hi Falco,
no, my running DB instance is PostGres 16.4

4

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 of 15.

4 Likes
5

That was the right lead, many thanks @pfaffman !!

Installed the postgre client without version, and got the current one (17).

Tis solved! Many thanks !

1 Like