ERROR: schema "discourse_functions" does not exist

Discourse Discourse System Administration
1

Having been working on restoring a Discourse postgres backup created by the Discourse app using PG12 to a postgres DB on another server (macOS) and getting this error:

CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
psql:dump.sql:15525578: ERROR:  schema "discourse_functions" does not exist
psql:dump.sql:15525586: ERROR:  schema "discourse_functions" does not exist
psql:dump.sql:15525594: ERROR:  schema "discourse_functions" does not exist
psql:dump.sql:15525602: ERROR:  schema "discourse_functions" does not exist
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE

I will (again) drop the DB and try again with a fresh backup and post back.

1 Like
2

Tried again with a fresh backup:

CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
psql:unix-linux-community-2020-12-25-062345-v20201218000001.sql:15542599: ERROR:  schema "discourse_functions" does not exist
psql:unix-linux-community-2020-12-25-062345-v20201218000001.sql:15542607: ERROR:  schema "discourse_functions" does not exist
psql:unix-linux-community-2020-12-25-062345-v20201218000001.sql:15542615: ERROR:  schema "discourse_functions" does not exist
psql:unix-linux-community-2020-12-25-062345-v20201218000001.sql:15542623: ERROR:  schema "discourse_functions" does not exist
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
1 Like