Metadata Database

This Database is used for CyVerse Metadata service.

Initialize database

Access Database

ssh root@DB_HOST.com
psql -U postgres

Create required Database

# create metadata database with de user
create database metadata with owner de;

Add required extensions

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

Populate / Migrate the Database

Ensure the following before running the command: - Docker is installed on your host machine. - The host has network access to the target PostgreSQL database.

Clone the migration repository:

git clone https://github.com/cyverse-austria/metadata-db.git

Run the migrations using Docker:

docker run --rm \
  -v $(pwd)/metadata-db/migrations:/migrations \
  --network host \
  migrate/migrate \
  --database "postgres://de:$DE_PASSWORD@$DE_HOST/metadata?sslmode=disable" \
  -path /migrations \
  up