From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Rob Sargent Newsgroups: gmane.emacs.help Subject: Re: sql-postgres connect using URL Date: Fri, 28 Oct 2022 06:51:55 -0600 Message-ID: <44a90cd0-2749-50d7-4c8b-f35de0cce0f5@xmission.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="35920"; mail-complaints-to="usenet@ciao.gmane.io" User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Cc: help-gnu-emacs@gnu.org To: Yuri Khan Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Fri Oct 28 14:52:29 2022 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ooOqb-00092B-O0 for geh-help-gnu-emacs@m.gmane-mx.org; Fri, 28 Oct 2022 14:52:29 +0200 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1ooOqL-0000YE-Ix; Fri, 28 Oct 2022 08:52:13 -0400 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ooOqE-0000X1-6e for help-gnu-emacs@gnu.org; Fri, 28 Oct 2022 08:52:09 -0400 Original-Received: from out01.mta.xmission.com ([166.70.13.231]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ooOqB-00006o-Mf for help-gnu-emacs@gnu.org; Fri, 28 Oct 2022 08:52:05 -0400 Original-Received: from in02.mta.xmission.com ([166.70.13.52]:38480) by out01.mta.xmission.com with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.93) (envelope-from ) id 1ooOq7-009KMb-7J; Fri, 28 Oct 2022 06:51:59 -0600 Original-Received: from [155.98.131.0] (port=7997 helo=[10.128.56.136]) by in02.mta.xmission.com with esmtpa (Exim 4.93) (envelope-from ) id 1ooOq6-00Gslp-C0; Fri, 28 Oct 2022 06:51:58 -0600 Content-Language: en-CA In-Reply-To: X-XM-SPF: eid=1ooOq6-00Gslp-C0; ; ; mid=<44a90cd0-2749-50d7-4c8b-f35de0cce0f5@xmission.com>; ; ; hst=in02.mta.xmission.com; ; ; ip=155.98.131.0; ; ; frm=rsargent@xmission.com; ; ; spf=softfail X-XM-AID: U2FsdGVkX1+cmyZ3XZ/YZxcLOmBV/hKQ6yiCjKoFuUk= X-SA-Exim-Connect-IP: 155.98.131.0 X-SA-Exim-Mail-From: rsargent@xmission.com X-SA-Exim-Version: 4.2.1 (built Sat, 08 Feb 2020 21:53:50 +0000) X-SA-Exim-Scanned: Yes (on in02.mta.xmission.com) Received-SPF: pass client-ip=166.70.13.231; envelope-from=rsargent@xmission.com; helo=out01.mta.xmission.com X-Spam_score_int: -25 X-Spam_score: -2.6 X-Spam_bar: -- X-Spam_report: (-2.6 / 5.0 requ) BAYES_00=-1.9, NICE_REPLY_A=-0.001, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: "help-gnu-emacs" Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane-mx.org@gnu.org Xref: news.gmane.io gmane.emacs.help:140466 Archived-At: On 10/28/22 00:18, Yuri Khan wrote: > On Fri, 28 Oct 2022 at 11:46, Rob Sargent 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