Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1quiI3-001Pyv-Gy for pgsql-admin@arkaria.postgresql.org; Sun, 22 Oct 2023 23:55:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1quiHz-002LHe-Mr for pgsql-admin@arkaria.postgresql.org; Sun, 22 Oct 2023 23:55:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1quiHz-002LHW-Bx for pgsql-admin@lists.postgresql.org; Sun, 22 Oct 2023 23:55:24 +0000 Received: from mail-yb1-xb2d.google.com ([2607:f8b0:4864:20::b2d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1quiHx-001odW-Bp for pgsql-admin@lists.postgresql.org; Sun, 22 Oct 2023 23:55:22 +0000 Received: by mail-yb1-xb2d.google.com with SMTP id 3f1490d57ef6-d9a398f411fso2532385276.3 for ; Sun, 22 Oct 2023 16:55:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698018920; x=1698623720; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=ljtCCVW2m0H4rlS9e0Mlm593uq2qKUz6JyuqkaOoHZs=; b=HdtuDc9AMbiE9uvha3o8JG6eyEwGkj2OieVuYeRnzWgxXYxLWRYP8rVSb2vcxwl9Cb tLFvLGOZAigh5/aADVu7ZCx7w9nSXGKLnMl7ms2osAw/2qUFxDMa9lbn/8AfGmLLK/4e 1er8ZghlLrdHXbOBJgml1YZT61vy4vTHW1Wnb6gntE2bLXxTWn4sK+UtZmC6IHxYqTyW zqRvUkASEln79TnkneDiwA6Znl0apkrZfOrGjNpHA/5mzqpkXANIIzujzZycnc967qY+ sDZeCEof0MGWmHX8cTuqUyuyjIrcycRktOv+24JUWLT5HM/HKKhohBrNzoXlA0eMDsxn gTWw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698018920; x=1698623720; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=ljtCCVW2m0H4rlS9e0Mlm593uq2qKUz6JyuqkaOoHZs=; b=LsTEofmAa2yLkTD5VCqgHgWZtlh168X8arS3luCJcP11DG7W1odPbPXVv7CVSjvouC qBs6vToi/sfkrMsUVWsAANsRw8IZWHPCWBCigEi71Al9N9TRl6BG+BJPJqCmRUlKgX7Q sXqRiCdt7OqSrqcbmYzgjAyIiNGwT1U04//ErlEOMcJ9Sjg6d0Oz569xKORbwseM7+F8 ZZi0zEzGG3c5zWmBdczFKNwO067v5vxLP8SMElf5txAsjHliTSvbS21D/6Cs6k2nLu3g MZw2p75Elpi2q4lg3IffAXFIihGBskia9PlyphC1n3YfNb3Xo0t5OfjYzi0Iu3bPgnTW TYmw== X-Gm-Message-State: AOJu0YzJEhMb0049id0PcAu6fT6f/V0+K2lxQc/YMjvOm3bAW0laCfsg K9GWdICo6l8oUaTrMQ/m+1gw9F1Schk= X-Google-Smtp-Source: AGHT+IEapHazL5fhUxxbmAldZkKvHboQF885HwEBcoe85+Ubwj2/rNmcX+8ANkxxJ0AEd1d0D+4xhw== X-Received: by 2002:a25:ef0c:0:b0:d9a:60b6:1b05 with SMTP id g12-20020a25ef0c000000b00d9a60b61b05mr7308788ybd.63.1698018919829; Sun, 22 Oct 2023 16:55:19 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:2124:20ee:567:da69? ([2600:1700:bd2c:b810:2124:20ee:567:da69]) by smtp.googlemail.com with ESMTPSA id w10-20020a25ef4a000000b00d815cb9accbsm2288083ybm.32.2023.10.22.16.55.19 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 22 Oct 2023 16:55:19 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------QQeogHWY3aIZDz6A902dJr0D" Message-ID: <461f5da0-a96f-4417-bf23-74ad7f6bd05e@gmail.com> Date: Sun, 22 Oct 2023 18:55:19 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Need to run pg_dump from the laptop without entering the password Content-Language: en-US To: "pgsql-admin@lists.postgresql.org" References: <2194a8e8-f1cc-4c72-96cb-710dcd973094@gmail.com> From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------QQeogHWY3aIZDz6A902dJr0D Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 10/22/23 18:19, Erik Wienhold wrote: [snip] > The hostname in pgpass.conf is > case-sensitive (not mentioned in the docs), so it must match the exact > spelling as in the connection parameters. That annoys me to. no. end.  Hostnames being lowercase here, uppercase there, and mixed case somewhere else and all working just fine *except* .pgpass regularly bites me when scripting. -- Born in Arizona, moved to Babylonia. --------------QQeogHWY3aIZDz6A902dJr0D Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 10/22/23 18:19, Erik Wienhold wrote:
[snip]
The hostname in pgpass.conf is 
case-sensitive (not mentioned in the docs), so it must match the exact
spelling as in the connection parameters.

That annoys me to. no. end.  Hostnames being lowercase here, uppercase there, and mixed case somewhere else and all working just fine except .pgpass regularly bites me when scripting.

--
Born in Arizona, moved to Babylonia.
--------------QQeogHWY3aIZDz6A902dJr0D--