2023-10-02 01:51:38 -07:00
|
|
|
# TO INSTALL POSTGRES SCHEMA AND DATABASE
|
|
|
|
|
|
2023-10-02 06:23:32 -07:00
|
|
|
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
|
|
|
|
|
|
2023-11-24 02:41:19 -08:00
|
|
|
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;
|
