Connect to Postgres DB using TablePlus

1

Can someone please explain this in a simple step-by-step instruction? I’ve tried everything mentioned in similar posts, but nothing’s working.

I want to use TablePlus on Mac to view my app’s postgres database.

I ran fly proxy 5432 -a my-postgress-app-name

Now what?? Specifically:

What do I input for Host/Socket?

What do I input for User?

What do I input for Password? (I tried all of the passwords found using fly secrets list -a my-app)

What do I input for Database?

Any other settings to get this working?

Please be as specific as possible.

2
  • Host: localhost
  • Port: The port you use in your proxy command, so 5432
  • Database: You can leave blank and select it after you connect, or if you have a single app put in your app’s database name
  • User: postgres
  • Pass: Password that was output when you ran fly postgres create

If you didn’t save the password, not sure there’s an easy way to recover it.

1 Like
3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.