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?
Kind regards
Andreas.
On Sun, Nov 29, 2020 at 01:02:37AM -0500, Asheesh Laroia wrote:
> Package: dh-r
> Version: 20201117
> X-Debbugs-CC: mat...@debian.org
>
> Hi there!
>
> I looked through Debian for mentions of the
> public-udd-mirror.xvm.mit.edu hostname, which Mattias and I are
> deprecating in favor of udd-mirror.debian.net. See also
> https://lists.debian.org/debian-qa/2020/11/msg00011.html
>
> I discovered it in dh-r via this search:
> https://codesearch.debian.net/search?q=public-udd-mirror
>
> For many years, both hostnames have worked. We now expect the old
> hostname to stop working eventually.
>
> I'm attaching a patch, which I have tested by manually running psql
> with similar flags as how the script would run it:
>
> $ psql postgresql://udd-mirror:udd-mir...@udd-mirror.debian.net/udd -t
> udd -c "select version from new_packages where package =
> 'libnest2d-dev' ;"
> 0.4-26-g4d6fb4d-1
>
> This matches what I see at https://ftp-master.debian.org/new.html .
>
> In the patch, I chose to use a postgresql:// URL to specify how to
> access the mirror. In my opinion, this improves clarity
> by avoiding the need for the PGPASSWORD environment variable.
>
> There's some chance the patch is mangled; if so, I apologize. The
> intent should be reasonably clear.
>
> Best regards,
>
> Asheesh.
> _______________________________________________
> R-pkg-team mailing list
> r-pkg-t...@alioth-lists.debian.net
> https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/r-pkg-team
--
http://fam-tille.de
