Resetting Gitlab Omnibus Mattermost installation

Here’s what worked for me (use at your own risk):

  1. Login to the database

     sudo -u gitlab-psql /opt/gitlab/embedded/bin/psql -h /var/opt/gitlab/postgresql -d gitlabhq_production
    
  2. Drop mattermost DB

     drop database mattermost_production;
    
  3. Exit (\q) and run

     gitlab-ctl reconfigure
    

The last step will recreate the database

2 Likes