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 1p8UqJ-0006Hc-Il for pgsql-admin@arkaria.postgresql.org; Thu, 22 Dec 2022 23:19:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p8UqG-0002od-SB for pgsql-admin@arkaria.postgresql.org; Thu, 22 Dec 2022 23:19:12 +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 1p8UqG-0002oS-FH for pgsql-admin@lists.postgresql.org; Thu, 22 Dec 2022 23:19:12 +0000 Received: from mail-qt1-x82d.google.com ([2607:f8b0:4864:20::82d]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p8UqE-0001Hc-01 for pgsql-admin@lists.postgresql.org; Thu, 22 Dec 2022 23:19:11 +0000 Received: by mail-qt1-x82d.google.com with SMTP id x11so2553552qtv.13 for ; Thu, 22 Dec 2022 15:19:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=+PZAwIE/JYPoCRbkK4kxWCoHFbhhVtfO/ibLfDnlumI=; b=Ds3QYq+/PJpjWINKkdbgvXuwkeUEU73KfmmlNRQ+c9smAhfjtDtSer+7k6Y82H5Wm4 g/UwD/EiN7o+r3V0VlCoqc9usYh0T2ImqNvlt3MF9POi3DZZVmpWMNt7sFxc2dB6iEXI qfgiZXG8Z+j8h103Xf0GlfF4mxnjjz3LhfSCCmZA4xQ1zUbqWU33v5SylHnWYUCZWiYM 79DUhQ2bs+qiu7Yrk4LoH2tBZvLSRRsNB9BTeVtpy1ijK07ij51427XNusmDr5xCKYbM bmex7mBU7m4S0Rjx340aug/vXvBNHN7LQUkcRyVM4HTa740tBklQtDTIrjdSV6CJgHDL j49A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=+PZAwIE/JYPoCRbkK4kxWCoHFbhhVtfO/ibLfDnlumI=; b=1hzzC8u09ongm3YfbSd47VrzvE9fSSsgFgfW30G2/ISMCHB2vlLeZC3tEPpA1NtPqt /D9a4gQ51xwj8UPZ9Y7TKhmYmU5iS/DvXpuml7jKsais9WVgeh+bpWAn4BfJoAIr+NCh BXXSMlUixvu65Sk9qy+sCaNPkD9bNf+FfR1SsxmQQoMbEQMMJ8PGFF+/vPNsbLQ4Kmyd VwgGZ4CqajgXWcKYcGCvlH8NPM2KLsZo4HWjAlOqNoGfNVVX1ONJ8PayHDFRxPJBlm98 glUkKYfuQH9qZSb1fvxLWIriQx3cfHf1UDjaftLX+KuU3/3E/ZlSh8m2mkXRVMEdhaSR tWpg== X-Gm-Message-State: AFqh2kocx64NwxTUuHFVYi0ei4rXqi9FQ1Nxp+DeokWlBlgKzxgcQkGM GB7ztFqAvId/VNTqkhz6jChrn7K7fkY= X-Google-Smtp-Source: AMrXdXue2YoRezIbZ9FYQrny9L4WYd/hmqoPF3eIFWElL2zKBG1uB/qgaVLsqagV017Vaig6DOzNBg== X-Received: by 2002:ac8:5e8c:0:b0:3a8:2ab9:7fa1 with SMTP id r12-20020ac85e8c000000b003a82ab97fa1mr8786837qtx.10.1671751147351; Thu, 22 Dec 2022 15:19:07 -0800 (PST) Received: from ?IPv6:2601:14b:4100:252f:8d53:3e69:6500:1af4? ([2601:14b:4100:252f:8d53:3e69:6500:1af4]) by smtp.gmail.com with ESMTPSA id h19-20020a05620a245300b006f9e103260dsm1164394qkn.91.2022.12.22.15.19.06 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 22 Dec 2022 15:19:06 -0800 (PST) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.7\)) Subject: Re: Facing issue with cert authentication From: Ed Sabol In-Reply-To: <40ba97d7584f20dbf04ebedfc02cb1b8a146f45e.camel@cybertec.at> Date: Thu, 22 Dec 2022 18:19:05 -0500 Cc: Dhirendra Singh Content-Transfer-Encoding: quoted-printable Message-Id: <2C48BDC5-1CFA-4E89-9173-3D893D3D904C@gmail.com> References: <40ba97d7584f20dbf04ebedfc02cb1b8a146f45e.camel@cybertec.at> To: Pgsql-admin X-Mailer: Apple Mail (2.3445.9.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Dec 22, 2022, at 7:46 AM, Laurenz Albe = wrote: > That syntax is not supported by PostgreSQL, and I cannot think of a = better > way than to create the role with an upper case "S". That sounds like the solution for Dhirendra. Is there some trick to = doing that? Dhirendra said the username was converted to lowercase when he tried.... Thanks, Ed