2022-10-30.md

publish_date	tags
2022-10-30	flyio postgres

• Finally getting a chance to tinker with fly.io!

  • launch a Postgres DB with flyctl postgres create

• If you want to connect to a fly.io postgres with PgAdmin you need to proxy the internal url to localhost and on specfy port with the command

fly proxy 6543:5432 -a app-name Proxying local port 6543 to remote [app-name.internal]:5432

this exposes internal fly.io db to localhost:6543

https://community.fly.io/t/is-there-any-way-to-see-data-in-database-like-normally-we-can-connect-our-postgres-database-to-pgadmin/4280/11

• time to learn docker for node apps - https://www.youtube.com/watch?v=9zUHg7xjIqQ