fix-databases.sh

#!/bin/bash

psql -v ON_ERROR_STOP=0 --username "homestead" --dbname "postgres" <<-EOSQL
    CREATE USER homestead;
    ALTER USER homestead PASSWORD 'secret';
    CREATE USER homestead_reader;
    ALTER USER homestead_reader PASSWORD 'secret';
    CREATE DATABASE og_ckan_registry_local__dev;
    CREATE DATABASE og_ckan_registry_ds_local__dev;
    GRANT ALL PRIVILEGES ON DATABASE og_ckan_registry_local__dev TO homestead;
    GRANT ALL PRIVILEGES ON DATABASE og_ckan_registry_ds_local__dev TO homestead;
    GRANT ALL PRIVILEGES ON DATABASE og_ckan_registry_local__dev TO homestead_reader;
    GRANT ALL PRIVILEGES ON DATABASE og_ckan_registry_ds_local__dev TO homestead_reader;
    CREATE DATABASE og_ckan_registry_local__dev__test;
    CREATE DATABASE og_ckan_registry_ds_local__dev__test;
    GRANT ALL PRIVILEGES ON DATABASE og_ckan_registry_local__dev__test TO homestead;
    GRANT ALL PRIVILEGES ON DATABASE og_ckan_registry_ds_local__dev__test TO homestead;
    GRANT ALL PRIVILEGES ON DATABASE og_ckan_registry_local__dev__test TO homestead_reader;
    GRANT ALL PRIVILEGES ON DATABASE og_ckan_registry_ds_local__dev__test TO homestead_reader;
EOSQL