The Discourse README states that the minimum version of PostgreSQL is 9.1+. Judging from the rest of the documentation, the minimum should now be 9.2+. I’d submit a PR to fix this, but…
Backups created by Discourse include the statement CREATE SCHEMA IF NOT EXISTS backup
. Restores fail on PostgreSQL 9.2 because the IF NOT EXISTS
parameter for CREATE SCHEMA
was introduced in 9.3. Perhaps the minimum version should be documented as 9.3+ instead?