Re: sql-postgres connect using URL

[Jean Louis]

* Rob Sargent <rsargent@xmission.com> [2022-10-27 23:05]:
> I need to be able to supple option TCP options in my sql-postgres sessions.
> 
> I've tried the following, without effect so far.
> 
> |(setq sql-connection-alist '(db (sql-product 'postgres) (sql-database
> ("postgresql://myusername@host/dbname?keepalives_idle=69?other=...")))|

I think PostgreSQL listens on TCP port by default, so what you need to
supply are variables

(setq sql-database "my-db")
(setq sql-password "my-pass")
(setq sql-postgres-login-params (quote (user password server database)))
(setq sql-postgres-program "psql")
(setq sql-product (quote postgres))
(setq sql-server "my-remote-server")
(setq sql-user "my-user")


-- 
Jean

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

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