Connecting/Migrations in RDS

Posted on Jun 1, 2021

Goose

Since goose uses pq under the hood, to hit remote urls

goose postgres "user=postgres password=${PROD_PGPASS} dbname=test sslmode=disable host=database.rds.amazonaws.com" status

PSQL / RDS

I didnt have a default database created, so I needed to psql into it - summoning psql via docker container

docker run -it --rm jbergknoff/postgresql-client postgresql://postgres:${PROD_PGPASS}@database.rds.amazonaws.com:5432
https://bneil.me/notes/note_connecting_to_rds/