Re: sql-postgres connect using URL

[Jean Louis]

* Rob Sargent <rsargent@xmission.com> [2022-10-28 07:48]:
> This clearly works from the command line:
> 
>    psql
>    
> postgresql://postgres@csgsdb/postgres?&keepalives_idle=60&keepalives_interval=30&keepalives_count=10

I had no idea about it.

> I do get connected to the database, at least.  I'll have to wait for the
> time out to NOT happen :). Meanwhile I'm connecting with emacs in the usual
> way, then once connected I issue a
> 
>    \c host=hostname user=rolename keepalives_idle=60
>    keepalives_interval=30 keepalives_count=10

Then use variable sql-postgres-options to add extra arguments to
psql. 

You can also use ~/.psqlrc to set things up.


-- 
Jean

Take action in Free Software Foundation campaigns:
https://www.fsf.org/campaigns

In support of Richard M. Stallman
https://stallmansupport.org/