[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: sql-postgres connect using URL
From: |
Jean Louis |
Subject: |
Re: sql-postgres connect using URL |
Date: |
Thu, 27 Oct 2022 23:56:19 +0300 |
User-agent: |
Mutt/2.2.7+37 (a90f69b) (2022-09-02) |
* 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/
- sql-postgres connect using URL, Rob Sargent, 2022/10/27
- Re: sql-postgres connect using URL,
Jean Louis <=
- Re: sql-postgres connect using URL, Rob Sargent, 2022/10/27
- Re: sql-postgres connect using URL, Jean Louis, 2022/10/28
- Re: sql-postgres connect using URL, Rob Sargent, 2022/10/28
- Re: sql-postgres connect using URL, Jean Louis, 2022/10/28
- Re: sql-postgres connect using URL, Rob Sargent, 2022/10/28
- Re: sql-postgres connect using URL, Jean Louis, 2022/10/28
- Re: sql-postgres connect using URL, Rob Sargent, 2022/10/28
- Re: sql-postgres connect using URL, Yuri Khan, 2022/10/28
- Re: sql-postgres connect using URL, Rob Sargent, 2022/10/28
Re: sql-postgres connect using URL, Emanuel Berg, 2022/10/28