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#

[이미지] 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 change …

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…

백업 복원 실패

지원 자체 호스팅

chapoi 6월 16, 2026, 10:45오전 8

아, 아직 데이터베이스에 들어가지 않은 상태군요.

먼저 psql -U discourse discourse를 실행해 보세요 (이렇게 해야 할 것 같습니다).

그럼 프롬프트가 discourse=#로 변경되어야 합니다.

글		댓글	조회수
Restore fails: could not create unique index Self-hosting	10	1320	2월 13, 2022
Restore fails - could not create unique index Self-hosting	21	4125	7월 4, 2020
Error restoring backup "key is duplicated" Self-hosting	7	1917	8월 30, 2017
Error on restore: could not create unique index Self-hosting	1	1860	3월 12, 2022
Error importing backup: "could not create unique index" Self-hosting	6	1117	11월 1, 2021

백업 복원 실패

Related topics