Hey guys, as I wrote in this post [이미지] Supported postgresql versions Self-hosting 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…

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 …

[이미지] Wurzelseppi: that a statement which has been added in PostGre 17 Was your backup taken from a PostgreSQL 17 instance?

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

That was the right lead, many thanks @pfaffman !! Installed the postgre client without version, and got the current one (17). Tis solved! Many thanks !

PostGres 17 백업 내 문구가 복원 메커니즘을 차단하고 있습니다

제품 지원

Falco (Falco) 2월 3, 2025, 2:41오후 2

백업이 PostgreSQL 17 인스턴스에서 생성된 것인가요?

글		댓글	조회수
Timeout when restoring a backup Self-hosting	1	941	11월 16, 2020
Backups fail with Postgres 16 database (and all PG>13) Product Support	7	997	6월 14, 2025
Supported postgresql versions Self-hosting	17	3677	3월 2, 2025
Trouble with restore: "invalid command \restrict" Product Support	2	1638	10월 29, 2025
Restoring backup fails due to Postgres version mismatch Self-hosting	5	3412	2월 14, 2019

PostGres 17 백업 내 문구가 복원 메커니즘을 차단하고 있습니다

Related topics