Go to file
GroovieGermanikus 29b1620741
Postgres: use TEXT everywhere
2023-12-22 11:51:59 +01:00
.github/workflows Add fly deployment action 2023-11-28 03:06:39 +00:00
.idea minor cleanup 2023-11-23 13:52:56 +01:00
src Postgres: use TEXT everywhere 2023-12-22 11:51:59 +01:00
.dockerignore WIP: fly config 2023-11-22 19:33:12 +01:00
.gitignore Intiail Commit 2023-09-28 16:26:09 +02:00
Cargo.lock Adding support for address lookup tables (#26) 2023-12-21 11:20:55 +01:00
Cargo.toml Feature/cleanup job (#28) 2023-12-21 14:39:18 +01:00
Dockerfile Feature/cleanupdb binary fly (#30) 2023-12-21 16:37:38 +01:00
README.md get banking blocks from rpc 2023-11-24 11:41:19 +01:00
fly.toml Fix metrics path 2023-11-23 14:48:13 +00:00
migration.sql Postgres: use TEXT everywhere 2023-12-22 11:51:59 +01:00

README.md

TO INSTALL POSTGRES SCHEMA AND DATABASE

sudo -u postgres psql postgres

in postgres

create data create database mangolana; grant all privileges on database mangolana to galactus;

psql -d mangolana < migration.sql

export PG_CONFIG="host=localhost dbname=mangolana user=galactus password=test sslmode=disable"

give rights to user

GRANT ALL PRIVILEGES ON DATABASE mangolana TO galactus; GRANT ALL PRIVILEGES ON SCHEMA banking_stage_results TO galactus; GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA banking_stage_results TO galactus; ALTER DEFAULT PRIVILEGES IN SCHEMA banking_stage_results GRANT ALL PRIVILEGES ON TABLES TO galactus;