Add separate Postgres user for Rosetta API

LimeChain / hedera-mirror-node

Hedera Mirror Node mirrors data from Hedera nodes and serves it via an API

Apache License 2.0

0 stars 1 forks source link

Add separate Postgres user for Rosetta API #126

Open Daniel-K-Ivanov opened 4 years ago

Daniel-K-Ivanov commented 4 years ago

At the moment we are using the mirror_node user for the DB connection at Rosetta. However, each service has its own user f.e

Importer has mirror_node
GRPC has mirror_grpc
REST API has mirror_api

We should add new user mirror_rosetta and use that from the Rosetta Service

Daniel-K-Ivanov commented 4 years ago

Switch the docker-compose from mounting hedera-mirror-grpc/scripts/db/init.sh and instead mount hedera-mirror-importer/src/main/resources/db/scripts/init.sql. The postgres image supports .sql files in /docker-entrypoint-initdb.d as well. Modify init.sql as necessary to make it work. Suggestion: add if not exist to the statements.

The Helm charts should be updated with the new user creation as-well