Pg_dump timed out

Bugs
1

INFORMATION

Relevant information to this issue:

  • OS:
  • databases: postgresql
  • Programming language and version:
  • Link to your project on GitHub/Gitlab:
  • Link to your application: Qovery

ISSUE

We use to do a pg_dump in order to fetch a dump of our Staging DB locally. For a few days, we are now getting a timed-out error.

pg_dump: error: connection to database "postgres" failed: could not connect to server: Operation timed out
	Is the server running on host "my_hostname.hel.sh" (xx.xxx.xx.xxx) and accepting
	TCP/IP connections on port 5432?

Note: connecting to the DB to query it from outside AWS works properly.

HOW TO REPRODUCE

pg_dump -Fc postgres://my_username:secretPassword@my_hostname.hel.sh:5432/postgres > backup.dump

Do you have any suggestions on how to solve that issue? Did you change any permissions preventing us from doing a pg_dump?

Thanks in advance for your help

2

Hello @jmeiss,

Is the pg_dump command is executed by the ‘DB migration’ job?

3

Hi @Pierre_Gerbelot,

Thanks for your reply.
Yes pg_dump from our DB migration job works well on our review apps and now I know it works on someone else laptop (from another country/network).
But we are two facing the same issue from the same network but also from a different one (tethering).
Meaning that it might come from our side but we can’t figure out what’s different since a few days ago :confused:

This morning we are still having the following error:

pg_dump: error: connection to database "postgres" failed: could not connect to server: Operation timed out
	Is the server running on host "xxxxx-postgresql.xxxxx.hel.sh" (xx.xxx.xx.xxx) and accepting
	TCP/IP connections on port 5432?
4

Hello @jmeiss ,

Your command is working on my side. Maybe you can run it with the --verbose option to see if there is anything relevant in the logs.

5

A co-worker tried through his VPN and it seems to work. I’ll try again when I’ll be back home since it might come from the coworking network we are currently connected from.

Thanks a lot for your suggestion @Pierre_Gerbelot :pray: