From: "Abraham, Danny" <danny_abraham@bmc.com>
To: Francisco Olarte <folarte@peoplecall.com>
CC: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade
 assumes it)
Thread-Topic: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade
 assumes it)
Thread-Index: Adupa04JdBiA/l++RXSWyenCz2prSQABgZeAAAF48/k=
Date: Wed, 9 Apr 2025 17:45:44 +0000
Message-ID: <cc2290e0-4fdd-465c-a282-efd5101d2f1b@bmc.com>
References:
 <SA1PR02MB96986CA15EEF976BFE16D2F28EB42@SA1PR02MB9698.namprd02.prod.outlook.com>
 <CA+bJJby+nA8OVs7AZKgGBX2Dx3ApvhEceWtFiq97crkiER2A=Q@mail.gmail.com>
In-Reply-To:
 <CA+bJJby+nA8OVs7AZKgGBX2Dx3ApvhEceWtFiq97crkiER2A=Q@mail.gmail.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?xBY5igEEJl62GTUWArVsxyXMP2F0ce2A0Qi7fOeU7iO9MgUvBMWkjAJQgh/I?=
 =?us-ascii?Q?+TXppUKjBsPoBJcghCn+SWrh7a3x7eX0oGiN+zHsaHgAapB0wCMLouzdNT6f?=
 =?us-ascii?Q?Dwq8Qk6H7UPawiDn08kVn2Be/rC9B1eR9ZCrYIN6vxOGRrap7VYzrYMZbndn?=
 =?us-ascii?Q?pCqQVUtYDkmBPnWNcF7dAfI4fa7u0awNGhw7JnDuTkaCVdr0u/yoIDUaa/kQ?=
 =?us-ascii?Q?XL/Z+ImwuGwZV4p9vDTMSw7WA82Dz36aBm50Ho89zB3Ii/4kniGwJVZvCj8v?=
 =?us-ascii?Q?SmIWWxF0zXknzh7bBJCGqtH2FA9Mb0qc2S5FpphhNyIOmeJicPz1/6BJex/W?=
 =?us-ascii?Q?drWdEpF02qxzpRhDQxbTB7pTGPkBLazv9V+m1l7s+cMPDSM/XRB6VQkKWQXj?=
 =?us-ascii?Q?v1LNSDe5SLGtpcgkUWE6uw2/mrNlgo+xWf+7/5X+1S81UMWbD8c8dx7GbWmL?=
 =?us-ascii?Q?e5wcKdFigWk55IecLBgPMg3OZvzkbdZbS+HsKOuby5QWksOMpOzP9qO4vIGJ?=
 =?us-ascii?Q?4PtCD5ScMvqnC6do5NEr+ylwuPr7jlQJTasmHEcoqN8Dr5DjGSMrytw+y3CD?=
 =?us-ascii?Q?4IFHV5sqyObD0miasTwDg26P4sfOgCxvWmMLUpU9dBZAU6YrxNk803Jf3Ws7?=
 =?us-ascii?Q?zj90It0CAU360qfyzUTfW9dlcutVI9txcyn0vKbESC2hLZ7Nko8BO9dIY0wn?=
 =?us-ascii?Q?HL5nnGwQBfiEoOIOFN7s2cuEZf8ffkHytAmJNkL0/yvpSrPLMIn/bKL9+3Vf?=
 =?us-ascii?Q?6+/8MiCzsvYqjD9ekIQy1MiEAfDQtBydUalCqgh99zH9VtaJEGJOX/upV6eO?=
 =?us-ascii?Q?XG+UkNCgPUrwS/9ORIoQx9nWvbBADTEhqRs5ecDyF3FkCfEv3QTO/NrYgmHQ?=
 =?us-ascii?Q?vOwkLPhpFTwE3z3pH7jiwo0A9szeuZFkCjH8jX0qknNYt+bfE1Cw2XNtEVlq?=
 =?us-ascii?Q?hXH65flFFX7yMOgdOWQ/T3YzDzEErW7hG73vgw1tBUCuyOa3OqpFk3PBXFdB?=
 =?us-ascii?Q?Lr0A7ucBkGNJJQ48byH/T+zSNblLOBOUsiryw9L24qdQ1sd9H8ghl7u8NNRi?=
 =?us-ascii?Q?dMq3Zro0qhk6oDqO6lHl1Jt+Vyf892OmRiwgfx+GsQ0IOImmY4uMx90pi8W4?=
 =?us-ascii?Q?qeKsmV4AlXGySKp4+B8r/IMu/GUD2soGW8RVgtOft8M6YUtuPKi9TMwVPXqI?=
 =?us-ascii?Q?g1AILvWb/AZaBXL6kl67ecZo+LeznzZZ1vb6/KUjBgmSUL78CxJ87/KmMZdg?=
 =?us-ascii?Q?gX0LtajgnD8+tqbUrUU+TdnFPmggzENsYA9UwCrJ/U4p6FArLIdiZ9wBobM0?=
 =?us-ascii?Q?XZRAco0XidSAeI3JV96lEgzH995r/lWa04gMlOY1nGgkTPsoK0huqy119Mla?=
 =?us-ascii?Q?e9cqyHNQUlDO5jaTnqpDBEtTHd+UpHbQRB5WFVqgYr205AJZp+ibrXSAoaiY?=
 =?us-ascii?Q?3oRbOMaNcl4nFgjN2yW0IiwNjobkYMvjEcF3wq2a2wIeiR6WvkDV55uqGWKb?=
 =?us-ascii?Q?9qqTLaXqawM/JsX0kAkNbJPrgi77XCT8NyMtbiGzPhP7RZu5QWjWKynPjp/H?=
 =?us-ascii?Q?Ew97w01T3em8qe9ISPBy6TPTenS7f+oyKXez8rdaPfqCGXOI9Yi7ckf9N437?=
 =?us-ascii?Q?xUnQWmeKpfYLkKV6ngFtGxDfRyBfgifOGVA7026+KXrO?=
Content-Type: multipart/alternative;
	boundary="_000_cc2290e04fdd465ca282efd5101d2f1bbmccom_"
MIME-Version: 1.0
X-OriginatorOrg: bmc.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: SA1PR02MB9698.namprd02.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: d510c294-15bd-406f-6b4b-08dd778e5ac6
X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Apr 2025 17:45:44.8105
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 92b796c5-5839-40a6-8dd9-c1fad320c69b
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: HbD/hRJW538OBLd6btKdnZnMmq2qDwr7jo1WsCs4gmLPARYr6GSliPWo+rXM0ILFtlfYzAuebVaQvrSgAt/VBQ==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: CH3PR02MB10010
X-Proofpoint-GUID: D0ObU40_In1JSTsAvDck_eRFIyOLiwP5
X-Proofpoint-ORIG-GUID: D0ObU40_In1JSTsAvDck_eRFIyOLiwP5
X-Authority-Analysis: v=2.4 cv=Cq2/cm4D c=1 sm=1 tr=0 ts=67f6b24c cx=c_pps a=eo5EBrZojstUK48b9mIPDA==:117 a=lCpzRmAYbLLaTzLvsPZ7Mbvzbb8=:19 a=wKuvFiaSGQ0qltdbU6+NXLB8nM8=:19 a=Ol13hO9ccFRV9qXi2t6ftBPywas=:19 a=xqWC_Br6kY4A:10 a=XR8D0OoHHMoA:10
 a=uF0kXBFlZFoA:10 a=OqsdhEO3AAAA:8 a=Zta1ebwbAAAA:8 a=87-1qcFFnkW288b-xTUA:9 a=CjuIK1q_8ugA:10 a=JslMwCKucQ0CdfBImIkA:9 a=cy2AXlT_G2ko7iNf:21 a=frz4AuCg-hUA:10 a=_W_S_7VecoQA:10 a=isetazAf3aTA-zOkrMAI:22 a=DvbVbmnX2b-Y7U9ai7vN:22
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.293,Aquarius:18.0.1095,Hydra:6.0.680,FMLib:17.12.68.34
 definitions=2025-04-09_06,2025-04-08_04,2024-11-22_01
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 spamscore=0 mlxlogscore=326
 priorityscore=1501 malwarescore=0 lowpriorityscore=0 suspectscore=0
 adultscore=0 impostorscore=0 phishscore=0 bulkscore=0 mlxscore=0
 clxscore=1015 classifier=spam authscore=0 authtc=n/a authcc=
 route=outbound adjust=0 reason=mlx scancount=1 engine=8.19.0-2502280000
 definitions=main-2504090116
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/cc2290e0-4fdd-465c-a282-efd5101d2f1b%40bmc.com>
Precedence: bulk

--_000_cc2290e04fdd465ca282efd5101d2f1bbmccom_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Failure eans going down the hba list and asking for the password.


Sent from Workspace ONE Boxer

On Apr 9, 2025 20:04, Francisco Olarte <folarte@peoplecall.com> wrote:
On Wed, 9 Apr 2025 at 18:20, Abraham, Danny <danny_abraham@bmc.com> wrote:
> Asking for help with inability to connect local using trust
> Fail
> #local   all         all                               trust
> #local   all   dbauser   peer
> OK
> #host    all          all         127.0.0.1/32          trust

How are you connecting? Your symptoms matches confusing local with
TCP/IP to localhost. They are not the same thing.
Also, are you on windows? ( which does not have unix sockets ).

local
This record matches connection attempts using Unix-domain sockets.
Without a record of this type, Unix-domain socket connections are
disallowed.
host
This record matches connection attempts made using TCP/IP. host
records match SSL or non-SSL connection attempts as well as GSSAPI
encrypted or non-GSSAPI encrypted connection attempts.

On a unix host psql -h localhost will use the host line, psql -h
/socket/path will go to the local one, and no -h defaults to socket.
On a windows host it default to tcp/ip to localhost.

Francisco Olarte.

--_000_cc2290e04fdd465ca282efd5101d2f1bbmccom_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; pad=
ding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<div>
<div dir=3D"ltr">Failure eans going down the hba list and asking for the pa=
ssword. </div>
<br>
<br>
<div dir=3D"ltr">Sent from Workspace ONE Boxer </div>
<br>
<div class=3D"x_bx-html">
<meta name=3D"Generator" content=3D"Microsoft Exchange Server">
<style>
<!--
.x_EmailQuote
	{margin-left:1pt;
	padding-left:4pt;
	border-left:#800000 2px solid}
-->
</style>
<div class=3D"x_bx-body">
<div class=3D"x_quote">On Apr 9, 2025 20:04, Francisco Olarte &lt;folarte@p=
eoplecall.com&gt; wrote:
</div>
</div>
</div>
</div>
<font size=3D"2"><span style=3D"font-size:11pt;">
<div class=3D"PlainText">On Wed, 9 Apr 2025 at 18:20, Abraham, Danny &lt;da=
nny_abraham@bmc.com&gt; wrote:<br>
&gt; Asking for help with inability to connect local using trust<br>
&gt; Fail<br>
&gt; #local&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
 all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; trust<br>
&gt; #local&nbsp;&nbsp; all&nbsp;&nbsp; dbauser&nbsp;&nbsp; peer<br>
&gt; OK<br>
&gt; #host&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 127.0.0.1/3=
2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; trust<br>
<br>
How are you connecting? Your symptoms matches confusing local with<br>
TCP/IP to localhost. They are not the same thing.<br>
Also, are you on windows? ( which does not have unix sockets ).<br>
<br>
local<br>
This record matches connection attempts using Unix-domain sockets.<br>
Without a record of this type, Unix-domain socket connections are<br>
disallowed.<br>
host<br>
This record matches connection attempts made using TCP/IP. host<br>
records match SSL or non-SSL connection attempts as well as GSSAPI<br>
encrypted or non-GSSAPI encrypted connection attempts.<br>
<br>
On a unix host psql -h localhost will use the host line, psql -h<br>
/socket/path will go to the local one, and no -h defaults to socket.<br>
On a windows host it default to tcp/ip to localhost.<br>
<br>
Francisco Olarte.<br>
</div>
</span></font>
</body>
</html>

--_000_cc2290e04fdd465ca282efd5101d2f1bbmccom_--