I’m trying to restore a backup from non-docker discourse installation to a docker based one. The backup process completed properly. But I cannot restore it after several tries of backup and restoring. Here’s the restore log: [2015-05-28 21:04:09] 'admin' has started the restore! [2015-05-28 21:04:…

dump.sql:23 contains: CREATE OPERATOR FAMILY btree_hstore_ops USING btree; dump.sql:4063, 4064 lines contain: COPY api_keys (id, key, user_id, created_by_id, created_at, updated_at, allowed_ips, hidden) FROM stdin; \.

But there must be an explanation what’s happening here, right? I don’t want to tinker with the backup unless it is absolutely necessary.

hstore is some extension for Postgresql. Presumable you have that on the non-Docker version, the backup script picks up the existance and tries to restore it on the Docker version?

[image] calmh: hstore is some extension for Postgresql. Presumable you have that on the non-Docker version, the backup script picks up the existance and tries to restore it on the Docker version? How do I confirm that? And what are the implications of it? It was installed with defaults on Ubu…

How about making the discourse postgres user a superuser? Should I do that? How? Any help @sam , @zogstrip , @codinghorror please?

I would extract the dump.sql file from the backup, comment out the line/s that is/are creating an operator family and overwrite the dump.sql file back in the backup.

Yeah, this. That line isn’t included in a normal backup, which means that there was some difference in your PG database versus a Docker-setup one.

It worked! Thanks @zogstrip , @riking !

Restoring from backup failed with ERROR: must be superuser to create an operator family

Product Support Self-hosting

riking (Kane York) May 28, 2015, 11:20pm 3

Try deleting the CREATE OPERATOR FAMILY line and doing it again.

Topic		Replies	Views
Trouble restoring from backup Product Support	10	1430	January 31, 2018
Backup restore failing on clean dev docker env: FATAL: Peer authentication failed for user “postgres” Bug pr-welcome , dev-install	14	4991	January 6, 2026
Errors on DB restore in Dev Development	2	891	October 28, 2018
Error when restore DB backup Self-hosting	25	2191	August 23, 2018
Restore failing- possible Data Explorer issue Self-hosting	21	2552	December 9, 2019

Restoring from backup failed with ERROR: must be superuser to create an operator family

Related topics