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; \.

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

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.

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

Product Support Self-hosting

mugli (Mugli) May 29, 2015, 8:02pm 10

It worked! Thanks @zogstrip, @riking!

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