Upgrade guide should point out incompatibility with Postgres 9.1
Summary
GitLab 9.1 breaks compatibility with Postgres 9.1. The change introducing this incompatibility was made in #30376 (closed), since Postgres 9.1 does not support DROP INDEX CONCURRENT
. The requirements point out that Postgres 9.5 is recommended since GitLab 9.0, but doesn't mention which version is actually required.
Steps to reproduce
Run database migrations on a Postgres 9.1 instance.
What is the current bug behavior?
The database migration fail with the logs pasted under "Relevant logs and/or screenshots".
What is the expected correct behavior?
The upgrade guide should point out that this release does not support Postgres 9.1, or only use CONCURRENTLY
on Postgres versions supporting this keyword.
Relevant logs and/or screenshots
-- execute("DROP INDEX CONCURRENTLY index_users_on_current_sign_in_at;")
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
PG::SyntaxError: ERROR: syntax error at or near "CONCURRENTLY"
LINE 1: DROP INDEX CONCURRENTLY index_users_on_current_sign_in_at;
Possible fixes
Update the upgrade guide for 9.1.