In my current setup, I’m hosting an RDS on AWS, in a private network (so it isn’t publicly accessible)
Using AWS SSM manager, I can overcome this, and run it locally:
aws ssm start-session --target <redacted> --document-name AWS-StartPortForwardingSessionToRemoteHost --parameters '{"host":[<redacted>],"portNumber":["5432"],"localPortNumber":["5500"]}' --region <redacted>
It works perfectly with DOTNET, and JetBrains DB connection. I just input a connection string like:
jdbc:postgresql://localhost:5500/postgres
, give it my username and password, and voila.
For DOTNET, I just use the connection string:
Server=localhost;Database=;User Id=;Password=;Port=5500
But, for some ODD REASON, PgAdmin just will not connect to this port forwaded instance.
I open PgAdmin -> Register -> Server PgAdmin Photo
I input all of the fields like I do for DOTNET / JetBrains:
Filling in the fields
But, it just doesn’t seem to work.
Connection Information added
Mikkel Andersen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.