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

Отношение "selected" не существует во внешнем Postgres

Поддержка продукта Самостоятельное хостинг

Falco (Falco) 23.Июль.2019 23:14:39 4

Это нормально: в данном случае selected — это CTE.

Какая версия PostgreSQL используется «в другом месте»?

Тема		Ответов	Просм.
PG::UndefinedTable: ERROR: relation "pg_range" does not exist Development	9	1825	12.01.2023
PG::UndefinedTable: ERROR: relation "translation_overrides" does not exist Development	4	4132	20.05.2026
Failed to handle exception in exception app middleware : PG::UndefinedTable: ERROR: relation "themes" does not exist Product Support	2	915	07.02.2019
Error "relation 'users' does not exist" when installing discourse Self-hosting	3	2729	17.01.2019
How to troubleshoot database errors in an outdated plugin? Development	5	494	29.02.2024

Отношение "selected" не существует во внешнем Postgres

Связанные темы