Failed to start mattermost web after restart about mattermost-server

[jwilander]

Hi maxlazio,

Which version of Postgres are you running? My guess is it's below 9.4 and that's causing the issue. Specifically, if I'm correct, it's being caused by the query we use to check for existing indexes in PostgreSQL. We're doing a SELECT to_regclass(stuff) and to_regclass looks like it's new in PostgreSQL 9.4+.

I imagine this is an issue for you guys and we need to support lower versions of PostgreSQL. If you can give me the lowest version of PostgreSQL that you need to support I can go and make sure we support that as well.

[maxlazio]

@jwilander Thanks for the quick response.

We are running 9.2(.10) by default, going lower than that version is unlikely to happen.

[jwilander]

Sounds good, I'll go make sure we can support at least 9.2. I'll link the PR to this issue when it's going in. Hopefully it should only take me an hour or two at most.

[maxlazio]

@jwilander awesome, no rush as there is enough to keep me occupied anyway :)

[jwilander]

Ok @maxlazio the fix has been merged into master and I also made sure nothing else would break with PostgreSQL 9.2.

Let me know if it works for you and I'll close the issue.

Also feel free to let me know if you need help with anything else :)

[maxlazio]

Works now, thanks for the quick turnaround!