Skip to main content

One post tagged with "PostgreSQL"

PostgreSQL integration and querying

View All Tags

Reach On-Prem Postgres and SAP from a Cloud Container — Without Opening a Port

· 8 min read
Joachim Rosskopf
Co-Founder & CEO

A cloud container reaching an on-premise Postgres and SAP system through a DuckDB gateway on a Tailscale tailnet, with no inbound firewall port.

Here is a problem that shows up on every hybrid-cloud project eventually. You have a container in the cloud — an AWS ECS task, a Fargate job, an analytics or AI workload — and it needs data that lives in an on-prem network: a Postgres database, or an SAP system reachable only from inside the corporate LAN.

The data is right there. The container just can't reach it. And the moment you ask, the answer from the network team is no: no inbound firewall port to the on-prem network, no public IP on the database, no exception. That's not obstruction — it's the correct default. An open port into your ERP network is exactly what you don't want.

So the usual workarounds start: a site-to-site VPN, a bastion host with SSH port-forwards, an IP allowlist someone has to maintain, a reverse proxy in a DMZ. Each one is a standing piece of infrastructure, and each one is a thing that can be misconfigured into an open door.

There's a smaller way to do this, and it doesn't open a port at all.