Connecting/Migrations in RDS

One-minute read

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