I’m having the following problem. I’ve been running a Discourse forum for over 10 years, and since I haven’t been able to install updates for some time now, I wanted to set up a new server: Old server is running: 3.4.0.beta4-dev New server: Latest version The backup is already 673.2 MB in size as…

Hello and wow, welcome back after 9 years! Pretty cool to see such a long running forum. I think this is the same index problem as talked about here: Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) It’s something like this: The incoming_referers table t…

Thank you very much for the quick response; I’ll give that a try!

Sorry to bother you, but I seem to be doing something wrong—after running the command “discourse=# select * from incoming_referers where path LIKE ‘%/search/’ ORDER BY incoming_domain_id;”, I’m getting a syntax error.

Did you type “discourse=#”? If so, try again without that

Then I get the error message “bash: syntax error near unexpected token `from’” For reference, I’m currently at: root@community-app:/var/www/discourse#

[immagine] Michael_Furtenbach: Then I get the error message “bash: syntax error near unexpected token `from’” For reference, I’m currently at: root@community-app:/var/www/discourse# Ah , you’re not in the DB yet. First run psql -U discourse discourse (I think) And then the prompt should ch…

Okay, I’ve now also installed “apt install postgresql-client-common.” However, I’m still getting the error “Error: You must install at least one postgresql-client- package.”

Okay that I don’t know. Maybe try directly via the rails console then: rails c with ActiveRecord::Base.connection.execute(<<~SQL) SELECT id, path, incoming_domain_id FROM incoming_referers WHERE path = '//' AND incoming_domain_id = 5 SQL That may give you the same without going throug…

I’m really, really sorry for acting so stupid. I’ve now installed Rails, and it seems to have worked. I also ran it with “rails c”. That seems to work too, but when I enter the command, it looks like this: “root@community:/var/discourse# ActiveRecord::Base.connection.execute(<<~SQL) -bash: syntax…

Don’t worry, maybe my instructions are just not that good :slight_smile: I will say I’m confused when you say you just installed Rails and can’t access your DB. Maybe it’s all different because it’s an older version, but I think I’m out of my depth now too. Anyway, once you’re in rails, the prompt…

Ripristino del backup non riuscito

Supporto Installazione

Michael_Furtenbach (Michael Furtenbach) 16 Giugno 2026, 7:25pm 22

Grazie infinite! Tutto è andato alla perfezione e, senza il tuo aiuto, non ce l’avrei fatta e avrei dovuto ricominciare da capo il forum, con grande dolore! GRAZIE!

Grazie anche a @chapoi per il grandissimo supporto!

Argomento		Risposte	Visualizzazioni
Restore fails: could not create unique index Self-hosting	10	1284	Febbraio 13, 2022
Restore fails - could not create unique index Self-hosting	21	4049	Luglio 4, 2020
Error restoring backup "key is duplicated" Self-hosting	7	1875	Agosto 30, 2017
Error on restore: could not create unique index Self-hosting	1	1804	Marzo 12, 2022
Error importing backup: "could not create unique index" Self-hosting	6	1069	Novembre 1, 2021

Ripristino del backup non riuscito

Argomenti correlati