On Sun, Nov 29, 2020 at 3:10 PM Andreas Tille <andr...@fam-tille.de> wrote: > > Hi Asheesh, > > I admit I applied your patch while beeing on a very poor connection and > I thought this would be the reason for a failure. But now beeing behind > a normal connection I get: > > LC_ALL=C psql postgresql://udd-mirror:udd-mir...@udd-mirror.debian.net/udd -t > udd -c "select version from packages where package = 'abacas' ; " > psql: error: could not connect to server: Connection timed out > Is the server running on host "udd-mirror.debian.net" (147.75.35.146) > and accepting > TCP/IP connections on port 5452? > > Is this a temporary issue or is something wrong with the query?
Sorry for the trouble! I think the problem is that you're connecting to this server on a non-standard postgres port number. The issue appears to be that UDD itself is on port 5452 [1], but postgres's default is 5432 [2]. I'm not sure what causes your script to use port 5452 -- perhaps the PGPORT variable is being used? The simplest approach might be to add the port number to the URL. The cleanest approach (IMHO) is to only use the PGPORT= environment variable in the case that you're using real UDD, and/or to use a URL to access real UDD. FWIW, I can reproduce the timeout with these commands. $ LC_ALL=C psql postgresql://udd-mirror:udd-mir...@udd-mirror.debian.net:5452/udd -t udd -c "select version from packages where package = 'abacas' ; " $ PGPORT=5452 LC_ALL=C psql postgresql://udd-mirror:udd-mir...@udd-mirror.debian.net/udd -t udd -c "select version from packages where package = 'abacas' ; " When I try these commands, there's no timeout: $ LC_ALL=C psql postgresql://udd-mirror:udd-mir...@udd-mirror.debian.net:5432/udd -t udd -c "select version from packages where package = 'abacas' ; " $ PGPORT=5452 LC_ALL=C psql postgresql://udd-mirror:udd-mir...@udd-mirror.debian.net:5432/udd -t udd -c "select version from packages where package = 'abacas' ; " Given all that, the simplest approach would probably be to add the port number (5432) to the script. Happy to give further advice or chat more. I'm open to reconfiguring udd-mirror to listen on port 5452 if that ends up being the best approach. Asheesh. 1. https://wiki.debian.org/UltimateDebianDatabase/ 2. https://www.iana.org/assignments/service-names-port-numbers/service-names-port-numbers.xhtml?search=postgres
