QMS Database

This Database is used for CyVerse QMS service.

Initialize database

Access vm

ssh root@DB_HOST.com

Create required Database

# create qms database with de owner
create database qms with owner de;

Add required extensions

# psql -U postgres
\c de
create extension "uuid-ossp";
create extension "moddatetime";
create extension "btree_gist";
create extension "insert_username";

Populate Database

TODO

Migrate Database

Once a while upon updating the k8s services, we would require to migrate the qms-database, to add the latest database changes.

Clone QMS repo

git clone https://github.com/cyverse/QMS.git
git fetch && git checkout prod
cd QMS

install golang-migrate

These steps are used on Ubuntu debian based OS.

curl -s https://packagecloud.io/install/repositories/golang-migrate/migrate/script.deb.sh | sudo bash
apt-get update
apt-get install -y migrate

# check
migrate -help

Run to migrate QMS database

Note: we are running the /migration directory from QMS

migrate -database postgres://USER:PASSWORD@DB_HOST.com/qms?sslmode=disable -path migrations up