Postgres Tips
Mar 23, 2022
docker run -e POSTGRES_USER=build-service -e POSTGRES_PASSWORD=secret -e POSTGRES_DB=build_service -p 54321:5432 postgres:12psql -h localhost -p 54321 -d build_service -U build-service
more info
AWS RDS
Create a custom db and grant admin_user permission.
$ psql -h commondb.foo.amazonaws.com -d postgres -U ldev
Password for user ldev:
postgres=> create database commondb;
CREATE DATABASE
postgres=> grant all privileges on database commondb to ldev;
GRANT
postgres=>
\q$ psql -h commondb.foo.amazonaws.com -d commondb -U ldev
Password for user localdev:commondb=>
\q
Create another postgres, username and password. Grant all priviledges to postgres user.
from postgres-client pod
$ k exec -it postgres-client -- bash$ psql --host=postgres-foo.amazonaws.com --dbname postgres -U ldevpostgres=> create database staging;
CREATE DATABASE
postgres=> create user stgusr with encrypted password 'spwd';
CREATE ROLE
postgres=> grant all privileges on database staging to stgusr;
GRANT