Hello, I’m trying to set up a discourse server hosted off of a pair of servers that will act as a failover pair–to do so I need them to talk to the same database. I already have a postgres server running elsewhere so I followed the instructions here and it appears to connect okay. When I try to reb…

Oh that is too old. Minimum supported version currently is PostgreSQL 10.

Does the database exist at all?

It is—there are 125 tables in total when I access the database

[画像] jhuddle1: When I go to the discourse database, there is no ‘selected’ table present. That is expected, selected in this case is a CTE . [画像] jhuddle1: I already have a postgres server running elsewhere What is the PostgreSQL version “elsewhere” ?

The version running on our database server is 9.4.22

外部 Postgres で Relation "selected" が存在しません

製品サポートインストール

Falco (Falco) 2019 年 7 月 23 日午後 11:14 4

それは想定通りです。この場合の selected は CTE です。

「別の場所」で動作している PostgreSQL のバージョンは何ですか？

トピック		返信	表示
PG::UndefinedTable: ERROR: relation "pg_range" does not exist Development	9	1825	2023 年 1 月 12 日
PG::UndefinedTable: ERROR: relation "translation_overrides" does not exist Development	4	4132	2026 年 5 月 20 日
Failed to handle exception in exception app middleware : PG::UndefinedTable: ERROR: relation "themes" does not exist Product Support	2	915	2019 年 2 月 7 日
Error "relation 'users' does not exist" when installing discourse Self-hosting	3	2729	2019 年 1 月 17 日
How to troubleshoot database errors in an outdated plugin? Development	5	494	2024 年 2 月 29 日

外部 Postgres で Relation "selected" が存在しません

関連トピック