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 rebuild the app, however, I’ve been getting the error: I, [2019-07-23T17:33:20.623719 #14] INFO – : > cd /var/www/discourse && su discourse -c ‘bundle exec rake db:migrate’ rake aborted! StandardError: An error has occurred, this and all later migrations canceled: PG::UndefinedTable: ERROR: relation “selected” does not exist LINE 7: OR (t.closed AND tsp.execute_at >= now()) ^ : WITH selected AS ( SELECT tsp.id FROM topic_status_updates tsp JOIN topics t ON t.id = tsp.topic_id WHERE tsp.execute_at = now()) ) UPDATE topic_status_updates SET deleted_at = now(), deleted_by_id = -1 WHERE id in (SELECT * FROM selected) When I go to the discourse database, there is no ‘selected’ table present. What can I do to fix this? I had an instance working when I had it locally off of once server–this only started happening once I moved the database.

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

Relation "selected" does not exist with external Postgres

תמיכה התקנה

Falco (Falco) 24 ביולי,‏ 2019,‏ 1:45pm 6

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

נושא		תגובות	צפיות
PG::UndefinedTable: ERROR: relation "pg_range" does not exist Development	9	1853	12 בינואר,‏ 2023
PG::UndefinedTable: ERROR: relation "translation_overrides" does not exist Development	4	4146	20 במאי,‏ 2026
Failed to handle exception in exception app middleware : PG::UndefinedTable: ERROR: relation "themes" does not exist Product Support	2	927	7 בפברואר,‏ 2019
Error "relation 'users' does not exist" when installing discourse Self-hosting	3	2741	17 בינואר,‏ 2019
How to troubleshoot database errors in an outdated plugin? Development	5	514	29 בפברואר,‏ 2024

Relation "selected" does not exist with external Postgres

נושאים קשורים