Re: sql-postgres connect using URL

[Yuri Khan]

On Fri, 28 Oct 2022 at 11:46, Rob Sargent <rsargent@xmission.com> wrote:

> This clearly works from the command line:
>
>     psql 
> postgresql://postgres@csgsdb/postgres?&keepalives_idle=60&keepalives_interval=30&keepalives_count=10

If you ran literally this without quoting or escaping the &s, I don’t
see how it could work. Here, you run four commands:

* ‘psql postgresql://postgres@csgsdb/postgres?’ in background
* empty command with environment variable ‘keepalives_idle’ set to
‘60’, in background
* empty command with environment variable ‘keepalives_interval’ set to
‘30’, in background
* empty command with environment variable ‘keepalives_count’ set to ‘10’

The last three have no effect and complete immediately. The first one
runs without any keepalive-related settings, and you can’t interact
with it because it’s in background.