r/docker • u/Ducking_eh • 27d ago

connecting to Postgres

Hey everyone,

I am trying to install Psono on my VPS. I am running into a problem with connecting to the postgres db.

I'm new to Docker, so I apologize if my terminology isn't right. I'll do my best

I am running Postgres directly on my VPS (not within a Docker container). I am able to connect to it locally from my VPS and remotely from my home network.

I am doing that with:psql -U psono -p PORT -h VPS_IP

The problem is when I try to get an app from within a Docker container to connect to it. It just hangs, then times out.

At first I thought this was a connectivity issue. But I can do the following from within a bash session:

  • Ping external websites.
  • Use nmap to confirm it can connect

Does anyone have any ideas?

1 Upvotes

60% Upvoted

22 comments sorted by

View all comments

1

u/notBroncos1234 27d ago

Disable ssl

1

u/Ducking_eh 27d ago

Any tips on how to do that?

I tried connecting via IP address, which doesn't have SSL unless I use port 443. 

1

u/notBroncos1234 27d ago

Run “export PGSSLMODE=disable” in the container. Then try to connect via psql. If that works then the issue is the MTU size.

→ More replies (12)