[Fixed]-Syntax error at or near "COLLATE" wagtail1.9 postgresql9.5.2

You probably have a PostgreSQL version older than 9.1 (first release in 2011, now out of support), when collations were introduced.

The solution would be to upgrade to a newer version of PostgreSQL.