Moving from self-hosted postgres to managed postgres, in the past we relied on using an ssh tunnel to connect to the server because we had access to postgres port locked down and we’ve been using VPN client that has dynamic ip on our end (so can’t lock our local IP down in firewall).
Now with hosted db, we lost ability to get ssh access, which means we can’t configure an SSH tunnel to connect to the postgres.
Any work arounds to still locking down access, but be able to connect to it from a dynamic IP?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.