Connect Postgres db hosted in azure storage using docker

Question

I am trying to connect the postgres database hosted in azure storage account from within the flyway, flyway is running as docker image in docker container

docker run --rm flyway/flyway -url=jdbc:postgresql://postgres-azure-db:5432/postgres -user=user -password=password info but I am getting the error ERROR: Unable to obtain connection from database

Any idea/doc-link would be helpful

This is stacktrace Caused by: org.postgresql.util.PSQLException: The connection attempt failed. Caused by: java.net.SocketTimeoutException: connect timed out — ABC
– ABC, Commented Mar 14, 2022 at 18:35
I am able to connect to postgress installed on my localhost from within docker, but if I am tryin to connect to posgres hosted on Azure that time unable to connect — ABC
– ABC, Commented Mar 14, 2022 at 18:37
Sounds like a firewall. They block you not by actively rejecting the connection, but just by ghosting you, leading to timeouts. — jjanes
– jjanes, Commented Mar 14, 2022 at 18:38

VonC · Accepted Answer · 2022-03-19 16:48:18Z

1

+50

You have a similar error (different context, same general solution) in this flyway issue

my missing piece for reaching private Cloud SQL instances from private worker pools in Cloud Build was a missing network route.
The fix is ensuring the Service Networking VPC peer has the "Export custom routes" setting enabled, and that the Cloud Router advertises the route.

In your context (Azure), see "Quickstart: Use Azure Data Studio to connect and query PostgreSQL"

You can also try with a local Postgres instance first, and Azure Data Studio, for testing.

answered Mar 19, 2022 at 16:48

VonC

1.4m569 gold badges4.8k silver badges5.7k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ABC · Accepted Answer · 2022-04-01 12:19:48Z

0

After exploring few option, I implemented the flyway using the Azure container instance. Create an ACI to store the flyway docker image and to execute the commands inside ACI, Also created a file share to keep the config file and sql scripts.

All these resource (Storage, ACI, file share) I created via the terraform scripts which is being triggered from Jenkins.

answered Apr 1, 2022 at 12:19

ABC

4,39310 gold badges47 silver badges78 bronze badges

Collectives™ on Stack Overflow

Connect Postgres db hosted in azure storage using docker

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related