I’m having trouble doing a restore from “Discourse 3.5.0.beta9-dev - 04dbc622ab1e0197d16703ba47cf005ec93697ee” to current (6f06709643fa5e2253606c46f79d089ca3393ac9) [STARTED] 'system' has started the restore! Marking restore as running... Making sure /home/pfaffman/src/discourse-repos/discourse/tmp/restores/default/2025-10-28-201139 exists... Downloading archive to tmp directory... Extracting dump file... Validating metadata... Current version: 20251024020353 Restored version: 20250724012518 Enabling readonly mode... Pausing sidekiq... Waiting up to 60 seconds for Sidekiq to finish running jobs... Creating missing functions in the discourse_functions schema... Restoring dump file... (this may take a while) invalid command \restrict EXCEPTION: psql failed: invalid command \restrict If I remove these printf commands from database_restorer, it works: &1 CMD It looks like this commit. https://github.com/discourse/discourse/commit/2b6675f064c62211f231f2d57305d3bd6209b140 On the version where the backup was made (a cdck docker container) I have this : PostgreSQL 15.13 (Debian 15.13-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit and this is where I’m trying to restore (dev site running pg15 on the bare metal): PostgreSQL 15.13 (Ubuntu 15.13-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit I don’t understand what this code is trying to do, so I’m just confused.

You need to be on PG 15.14 and you need to make sure all your instances are on that. This patches a large security issue. PostgreSQL: CVE-2025-8714: PostgreSQL pg_dump lets superuser of origin server...

Aha. That’s a very simple explanation. Thanks. I’ll get on that.

Trouble with restore: "invalid command \restrict"

Product Support

Topic		Replies	Views
Restoring backup from 2.0.0.beta5 disables Discourse Bug	7	1262	April 12, 2018
Can't restore saved backup Self-hosting	3	1385	March 7, 2017
Error when restore DB backup Self-hosting	25	2269	August 23, 2018
Restore error -- database escape problem? Product Support	6	1479	September 2, 2016
Errors on DB restore in Dev Development	2	901	October 28, 2018

Trouble with restore: "invalid command \restrict"

Related topics