[DRE-maint] Bug#911123: ruby-sequel: PG adapter does not support `service` parameter keyword

[nyov]

Package: ruby-sequel
Version: 4.37.0-1
Severity: normal
Forwarded: https://github.com/jeremyevans/sequel/issues/1558

tags -1 + found 5.6.0-1
thanks

Dear Maintainer,

Sequel's pg adapter [1] does not support the libpq service parameter keyword [2].
It fully ignores a connection defined in the connection service file [3].

Tested were:

    Sequel.connect('postgresql://?service=test')
    Sequel.postgres('postgresql://?service=test')
    Sequel.connect('postgresql://', driver_options: { service: 'test' })
    Sequel.connect(adapter: 'postgres', driver_options: { service: 'test' })
    Sequel.postgres(adapter: 'postgres', driver_options: { service: 'test' })

Here Sequel does not connect to a (remote) `test` service connection defined in
`~/.pg_service.conf` but tries localhost:

    PG::ConnectionBad: could not connect to server: No such file or directory
    # or
    PG::ConnectionBad: FATAL:  role "www-data" does not exist


The issue was reported upstream.

[1] https://github.com/jeremyevans/sequel/blob/8b6f117ff47ff8c28f0b952cc20a07300b9f2ecb/lib/sequel/adapters/postgres.rb#L196-L203
[2] https://www.postgresql.org/docs/10/static/libpq-connect.html#LIBPQ-PARAMKEYWORDS
[3] https://www.postgresql.org/docs/current/static/libpq-pgservice.html


-- System Information:
Debian Release: 9.5
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'testing'), (500, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.9.0-8-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to en_US.UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to en_US.UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: sysvinit (via /sbin/init)

Versions of packages ruby-sequel depends on:
ii  ruby       1:2.3.3
ii  ruby-json  2.0.1+dfsg-3

Versions of packages ruby-sequel recommends:
ii  ruby-sequel-pg  1.6.16-1

ruby-sequel suggests no packages.

-- no debconf information