Usagi

Install

Create DB users

create database usagi;

# Create DDL User
CREATE USER usagi WITH PASSWORD '12.abblikatioN-Houser';
ALTER ROLE usagi WITH VIEWACTIVITY;
ALTER ROLE usagi WITH VIEWCLUSTERMETADATA;
CREATE DATABASE usagi;
ALTER DATABASE usagi OWNER TO usagi;

# Create runtime user
CREATE USER usagi_app WITH PASSWORD '2.tyPIcky-Runtime.USer';
GRANT CONNECT ON DATABASE usagi TO usagi_app;
GRANT USAGE ON SCHEMA public TO usagi_app;
ALTER DEFAULT PRIVILEGES FOR ROLE usagi_app
    GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO usagi_app;

Example ENV

# List of database strings LABEL1>DSN1,LABEL2>DSN2,LABEL3>DSN3
DSN_LIST="db-a>postgresql://usagi@localhost:25432/usagi?sslmode=disable,db-b>postgresql://usagi@localhost:35432/usagi?sslmode=disable,db-c>postgresql://usagi@localhost:15432/usagi?sslmode=disable"
# Listen address
LISTEN_ADDR=":9999"
# Authentication token
HTTP_AUTH_TOKEN="my-secret-token"

Example query file

SELECT 
    node_id, 
    address, 
FROM crdb_internal.kv_node_status;