Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kZTPR-00036s-3O for pgsql-bugs@arkaria.postgresql.org; Mon, 02 Nov 2020 06:33:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kZTPQ-0005tW-1s for pgsql-bugs@arkaria.postgresql.org; Mon, 02 Nov 2020 06:33:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kZTPP-0005t8-KC for pgsql-bugs@lists.postgresql.org; Mon, 02 Nov 2020 06:33:39 +0000 Received: from mail-io1-xd2c.google.com ([2607:f8b0:4864:20::d2c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kZTPN-0008Ls-1U for pgsql-bugs@lists.postgresql.org; Mon, 02 Nov 2020 06:33:39 +0000 Received: by mail-io1-xd2c.google.com with SMTP id u62so13866801iod.8 for ; Sun, 01 Nov 2020 22:33:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=LcjGy+yjFDpVDdaSBHtfF3MVWJdQu5JVowI5qpQxhP4=; b=JvnQpdLivfB+LHbN4TmD3vGBsS3+l8+HAxciOP2/BjQtLtNeZ6xXKHwzdTo4IQE8eP MGlnmA7Vb7mkpV7MtnyOQ8N+5Sld37Q8yR21J8VHnvvTtVZl8peBEM7ejKI8AF/LBgoW L4YQIEnzHmgJ/47XQE8FT3C1xHlV1OlkGGm+MycbXUQe0Wb8uSlhDBM6GO0OMy+EE5CH 4O3/0RoENTcb8E33I209HTU5aJV0ypY5PZysuQCoRO10ldG5Bf+J1/Gv8zUe5/JWP6LJ 5WFS1Qcdfk+MqI96Ip70fpZqccr3j1jiMvuGhfIFuPpvwwBptX5APKJpZSrGP5llzzuS Qf9g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=LcjGy+yjFDpVDdaSBHtfF3MVWJdQu5JVowI5qpQxhP4=; b=aLtbK6dSFlqNxT2uGn8foFxseJRjzuDO/NiI+lHtrtZGr+roz3RZbZo5VpGVDJYyEm ZMrZ+7aRBytGtaV7n69PgAm0yS2wEBMcOnVh3N+8qFZQBQbL1BsTCUSBi8cYR1fzi2RU jRweG6SUyX0oYHt+td2gpO4aCdreh+FpZr1vhgeRpWn4Sdbzu6aQhPZY8lTM73MmBzIj PCGF6tEBxq/AB6afo4pxDOeSYujKIJ9ioAQN3g3Ddfv00XlB9YolqHCNXHmtPtU4SdoF SSCUPwAHMTNURsrZtTmKRVvqLNZgzhPtJL5p7++uD9TXo1jZceE4z0L7sN1dlolNAuRQ hrGg== X-Gm-Message-State: AOAM530bjk1DBRhjVrbRTKm0ViK0exLEpfMMjuOYnaLcsqR7uoj5/pOx DOVgKf5r1bt9Xmfr2rygKqXlwg== X-Google-Smtp-Source: ABdhPJwznjmT8vhvmhwe9ugGQ/wYpp5AD+KWSYxbajpoEKlzI6xMW38mG62cZXVOfIgoaZnmi03x4w== X-Received: by 2002:a02:cc3c:: with SMTP id o28mr10346180jap.107.1604298815352; Sun, 01 Nov 2020 22:33:35 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id w12sm5342866iou.42.2020.11.01.22.33.34 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 01 Nov 2020 22:33:34 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 8D2A6800651; Mon, 2 Nov 2020 00:33:33 -0600 (CST) Date: Mon, 2 Nov 2020 00:33:33 -0600 From: Justin Pryzby To: Bruce Momjian Cc: Tom Lane , "David G. Johnston" , exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16486: Prompted password is ignored when password specified in connection string Message-ID: <20201102063333.GE22691@telsasoft.com> References: <16486-b9c93d71c02c4907@postgresql.org> <2090524.1591652199@sss.pgh.pa.us> <2110959.1591655226@sss.pgh.pa.us> <2142411.1591667958@sss.pgh.pa.us> <20200901203846.GA13613@momjian.us> <428207.1599076060@sss.pgh.pa.us> <20200903190538.GA3248@momjian.us> <20201003021958.GC17425@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20201003021958.GC17425@momjian.us> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, Oct 02, 2020 at 10:19:58PM -0400, Bruce Momjian wrote: > On Thu, Sep 3, 2020 at 03:05:38PM -0400, Bruce Momjian wrote: > > On Wed, Sep 2, 2020 at 03:47:40PM -0400, Tom Lane wrote: > > > Bruce Momjian writes: > > > > I used a later version of Tom's patch to add documentation of how > > > > connection strings can override command-line options, plus it has the > > > > password description improvements. > > > > > > > ) is not used, the database name is read > > > > from the environment variable PGDATABASE. If > > > > that is not set, the user name specified for the connection is > > > > - used. > > > > + used. Connction strings > > > > + can also be used for connection specifications, and these can > > > > + override other command-line options. > > > > > > > > > > > > > > > > > > * Spellcheck (not "Connction" please) ... > > Sure, makes sense. Updated patch attached. > > Patch applied to all supported versions; thanks for the report. Unfortunately that included the typo Tom pointed out :(