Re: sql-postgres connect using URL

[Rob Sargent <rsargent@xmission.com>]

On 10/28/22 00:18, Yuri Khan wrote:
> 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.
You're right.  single quote the whole argument