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 1kCoVj-0008Gi-Lo for pgsql-admin@arkaria.postgresql.org; Mon, 31 Aug 2020 18:26:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kCoVi-0004iv-KX for pgsql-admin@arkaria.postgresql.org; Mon, 31 Aug 2020 18:26:30 +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 1kCoVi-0004io-B4 for pgsql-admin@lists.postgresql.org; Mon, 31 Aug 2020 18:26:30 +0000 Received: from mail-oi1-x242.google.com ([2607:f8b0:4864:20::242]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kCoVf-0003lP-Pi for pgsql-admin@lists.postgresql.org; Mon, 31 Aug 2020 18:26:29 +0000 Received: by mail-oi1-x242.google.com with SMTP id e6so1810183oii.4 for ; Mon, 31 Aug 2020 11:26:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=mNk9cOWP0Ut4/M9Q/R/eWnYcGwEVTVqpGQm1xalXtmQ=; b=oLPriwrNNERbycyCM6rOJ1k+C5CGWZtNu3g/XXBNho3GDodxbQksYPvFhUCLBVXqkh w1DLzFi6SN17/u+76DebffLfp08ZbmK6epZ766VinIrDJ9eNafjj1SRFoybLHwxAn2wI xGZ/78mC/r8EEIkOe92UxpLgNqTKUBSB+exmUR8DJsaneXNtFqw/tCcM2xJf1UZY7SM3 tPl7mGFftcLA5Y9+lrEzKcd7EZ/evwbilzeL46fKvXXRW7mU68tsTpmne94uUQ8LFFsv an9gl6NLxgYKkwMmRaAhrLUWqYFLtrxV37AlSPN2XS+U8ymYE0FFk2P1Uoz/baDJLPWv BAPg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=mNk9cOWP0Ut4/M9Q/R/eWnYcGwEVTVqpGQm1xalXtmQ=; b=N66nYXhHnGGY6yzJaFjvOiLNJQRYi935OoTo0du6CE3qVZ7aXLfAGWRxkRuQzT7txO vRZ0fzM1bp4xvv01+mMhl4Wd7jd22rLHQmg9SlCrKoeBc4rC5ID7bMUwFC7Z4CRx5j/F zWMPq8+84aZ1qwAf6NkxWaf8JZzktY7yTZT0nxygEImdNqiCx6z4KqZ3yvi7Uca+iidH cECgDtG/h/PBxBWNRQ+eRavmTxY1/28gdIzupQRQedUweNeUDvKMdkNTGzAUZIePl4of Z7e8IKLZkwHbc7ZMGlLVDLInqJNd8rDY7Jh0cRjmMQBrwZ6mF2InlL/cJvriDyLc8Sqk pdfQ== X-Gm-Message-State: AOAM5308wNfJruuFXMR0WYanhrP/FbN+Vl8x+M5FGyiAcgCC8Ij1I2v5 9okgjtOsGOtqdatnAUhOT37WI1+4B/8Beg== X-Google-Smtp-Source: ABdhPJwQW7ZprQ7P1Xh/bZ+8REYpRFxnnSTYg5EWCRUBt/BldjAWqV6xAgLTD2edYFAbVrtJIfeYYg== X-Received: by 2002:a05:6808:142:: with SMTP id h2mr384853oie.113.1598898385836; Mon, 31 Aug 2020 11:26:25 -0700 (PDT) Received: from [192.168.1.10] (ip174-67-143-111.no.no.cox.net. [174.67.143.111]) by smtp.googlemail.com with ESMTPSA id x38sm58681ota.72.2020.08.31.11.26.24 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 31 Aug 2020 11:26:25 -0700 (PDT) Subject: Re: Amazon RDS auth tokens in .pgpass To: pgsql-admin@lists.postgresql.org References: <4119486.1598897040@sss.pgh.pa.us> <20200831181648.GT29590@tamriel.snowman.net> <4123590.1598898063@sss.pgh.pa.us> From: Ron Message-ID: <8c791ff3-3f48-99dc-4d33-cab8701d0997@gmail.com> Date: Mon, 31 Aug 2020 13:26:23 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: <4123590.1598898063@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 8/31/20 1:21 PM, Tom Lane wrote: > Stephen Frost writes: >> My memory might be faulty, but I've got some specific recollection of >> people complaining about this before and the community response being >> "who would ever need such very long things?!" > Yeah, so I guessed wrong ;-). Never too late to absorb new facts though. > > That thread does point out that passwordFromFile() is far from the > only place that assumes passwords aren't going to be longer than > what would be sane to enter manually. I wonder whether we need to > worry about the other bottlenecks. Would it be better to add a .pgtoken file which gets examined (and bypasses those other length restrictions) if the user isn't in .pgpass?  Or is that a feature which would have to wait for v14? -- Angular momentum makes the world go 'round.