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…

Does the database exist at all?

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

[image] jhuddle1: When I go to the discourse database, there is no ‘selected’ table present. That is expected, selected in this case is a CTE . [image] 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

Relation "selected" does not exist with external Postgres

Product Support Self-hosting

Falco (Falco) July 24, 2019, 1:45pm 6

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

Topic		Replies	Views
PG::UndefinedTable: ERROR: relation "pg_range" does not exist Development	9	1825	January 12, 2023
PG::UndefinedTable: ERROR: relation "translation_overrides" does not exist Development	4	4131	May 20, 2026
Failed to handle exception in exception app middleware : PG::UndefinedTable: ERROR: relation "themes" does not exist Product Support	2	914	February 7, 2019
Error "relation 'users' does not exist" when installing discourse Self-hosting	3	2729	January 17, 2019
How to troubleshoot database errors in an outdated plugin? Development	5	493	February 29, 2024

Relation "selected" does not exist with external Postgres

Related topics