Notifications Database¶
This Database is used for CyVerse notifications service.
Initialize database¶
Access Database¶
ssh root@DB_HOST.com
psql -U postgres
Create required Database¶
# create notifications database with de owner.
create database notifications with owner de;
Add required extensions¶
# psql -U postgres
\c notifications
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/notifications-db.git
Run the migrations using Docker:
docker run --rm \
-v $(pwd)/notifications-db/migrations:/migrations \
--network host \
migrate/migrate \
--database "postgres://de:$DE_PASSWORD@$DE_HOST/notifications?sslmode=disable" \
-path /migrations \
up