0

I am trying to connect to Postgres instance in AWS which has corporate restrictions.

  1. I first SSH to an AWS Ec2 instance - 2 3 custom actions on command line.
  2. Then I connect to the PostgreSQL instance by PSQL, and use the command line to execute SQL

Is there any way we can achieve the same using dbeaver or any other client?

Makjb lh
  • 432
  • 5
  • 16
  • Checkout for this: https://stackoverflow.com/questions/42403071/connecting-dbeaver-to-postgres-hosted-on-remote-server – ealmaraz Jun 14 '21 at 19:15

1 Answers1

0

It sounds like you want an SSH tunnel. DBeaver has an "SSH" tab under Connection Settings for setting this up.

Alternatively, you can use ssh with -L to set up a tunnel manually, and then point DBeaver to the designated local port on the localhost host.

jjanes
  • 37,812
  • 5
  • 27
  • 34
  • thihs method above do you have any other instructions. I need to provide multiple custom answers to the SSH tunnel .. designed by corporate.. – Makjb lh Feb 12 '21 at 19:58