I followed the Configuration in the Mattermost Database instructions but at the very end, the command
SELECT * FROM Configurations WHERE Active = 1; fails with
ERROR: relation "configurations" does not exist
I used my GUI client to connect to the DB and sure enough there is a table called
configurations with 2 records. One record has a null value for active, while the other has the string
t. Strangely, I cannot change the value
t to 1. Even stranger, from the CLI,
SELECT * FROM configurations; yields the same error message as above. But I see it in my GUI client!
Any help would be appreciated. Many thanks in advance to all!