💾 Archived View for shiny.bneil.me › notes › note_connecting_to_rds › index.gmi captured on 2024-08-25 at 00:11:16. Gemini links have been rewritten to link to archived content

View Raw

More Information

⬅️ Previous capture (2024-03-21)

-=-=-=-=-=-=-

Connecting/Migrations in RDS

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

---

updated: 2 October 2021.

to the Index

/ html