Error when restore DB backup

Hmm OK this is tricky but I have a temporary fix out for this.

The problem here is that the Discourse restorer only migrates table to the backup schema and not functions that we create. The fix here is to ensure that the restorer migrates functions created by the Discourse code base as well but I’ll need to work on a pattern to identify “Discourse PostgreSQL functions”. I’ll probably just namespace the functions that we create with _discourse_.

3 Likes