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++RXSWyenCz2prSQABgZeAAAFtdQs=
Date: Wed, 9 Apr 2025 17:44:27 +0000
Message-ID: <e5ff9605-80d6-4da9-a4ef-c6fa43bf4599@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?QgELEupN4Ao3l7eID92yMWdzHhscVnN6flAlmaOjKV1Qa28CrJbAElNrro2J?=
 =?us-ascii?Q?hqsuUOB938sRag63+WzqfNBk6h2bP8mPkzEEHx082yFC1u498VbfCU5G8fFt?=
 =?us-ascii?Q?fG4uD+3WpfcMPVQLpdt0r5GAVFsxPO0Q0bpL7AQ0lzXMArATWaCKb4itg69I?=
 =?us-ascii?Q?Al88pjut+j6jiXL3CMm7uU3O9/49UVrYzElLK+AaKh34MTGKjLn88nxA+X8J?=
 =?us-ascii?Q?GsSKUXV5toJYONO8tfhRCNoP+4ZGUyng5F7oE3gPyRWN5sMnxY9N3Dxjo+Sm?=
 =?us-ascii?Q?bAT4ZVmPZf3U0LGH35NryfVc9CnDHUFBfSPTp1LlVfYmtHe2o3pd5ekOYmdG?=
 =?us-ascii?Q?1+ZPeTAPKFyiCZPF87nMlMNvkV4BePpORS1AuamSLMFPplzmVJ9kjnXgL/dn?=
 =?us-ascii?Q?PQiupw+dJpYlaZVQAcVhlJhtOrzAii1/7CvMN1i25WjIoCJEZRC/Z/WHhFXv?=
 =?us-ascii?Q?6arkpAHaS4zeFNFv7mzzbOEki+FMx9y+SP4Ll/J/w/dKaGZTaTNEup8QJadz?=
 =?us-ascii?Q?pUW/tQR5JFgJpWapkCbH8SDwTqtIz4a6IrE2scL0MXk9Ku68FGa62XTDyiwq?=
 =?us-ascii?Q?uPWdiZC5AEyLEyQOyjnX4pqI5PiP4slWqU4D8BTi3C4b8KDQU//TRxui4mtn?=
 =?us-ascii?Q?LPWZ7qhx3ypPsgg6cvqCYKerPt8IRw+XlPeFEBt0aT5lscKXDLceWYeBnANj?=
 =?us-ascii?Q?jSjRFhPH2T8Vi7mwAgNP7k18sIkbAxFXkwAOsqyXNrAAHh79rUhiAsu3rfpq?=
 =?us-ascii?Q?Ecv25zFhB+DfxhbyXbUyNvqS6X3DGaqurDn72yfMu2fuFet93E604HF3xXNH?=
 =?us-ascii?Q?o8SeUqSnHBNMwYI4x1DdHpG8M5I+euJ2WCo5yWX1X4glS6epHOWx73spSkRS?=
 =?us-ascii?Q?NXh8hpu/vlizljqZzsZaNn6RnC/RLzvyicL4ZorhSyzA10L+bfyxblvUSx6i?=
 =?us-ascii?Q?0R3CtjrotpNummlcd9nqJuziX4auxWqLUPq57kOVTUJfc3sptN/oSBoXKRYU?=
 =?us-ascii?Q?mMX8GUZzvheyaVjYxoxmqic8JxJr/I2O69whbN/rVzKk074WpwT4LZm6l1V0?=
 =?us-ascii?Q?wxMkQgu49eE9Zuvbbm1koTBj54ayYQ3JH2EWIybGCf6HYAp2zbE1eBFSGZZj?=
 =?us-ascii?Q?1mbOPv+b/DsCktusOk1s1y2rF9B2+sM4K5HKaMZGlSipMtpQ/sHj6LhD1L1c?=
 =?us-ascii?Q?aAptgtf0JKpDAxQ/hCS57k5MjXdrYT48GiXg3l5wq9vLnfzidr45wmNUWGGD?=
 =?us-ascii?Q?xCLZ3XtDi/vjWpZxns8WuZ4ewYaKalzf9ULox6owyuDPFVZo21h3jwEnNeJJ?=
 =?us-ascii?Q?iloS9FAIoQv7HR4x5uEMmFzgVrL0ZaW+pV5mn0sqQIg11okH/FLrIX8nEDMg?=
 =?us-ascii?Q?WsKoScxNqNTZiiAmaWTRRgT9VHDr9n4BTUsIo4pvIuU8mTS2XCE9zjmM9M/D?=
 =?us-ascii?Q?FKsdzWX2WfKxjVT6wGACf5TIxRd09ZwJ7zNcj8gwIAeWvaFNGBfUVelfICSQ?=
 =?us-ascii?Q?L5+SIMIwGSd+upKEgxjxcfNjvlwzRZp4X/bzjndMgU1j+iQHqubhDbQG2gMd?=
 =?us-ascii?Q?DYYt5wRtG6mPKfkrArx7MnagAdvZpkPZqlK1Era3Jkbn00HbNmJzvkgUCOp5?=
 =?us-ascii?Q?NJPJvFSS+t1t2Chyrzf/8yQycC92RvivefB12XMyWnKV?=
Content-Type: multipart/alternative;
	boundary="_000_e5ff960580d64da9a4efc6fa43bf4599bmccom_"
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: c1fafc89-4b8a-4ddb-47a9-08dd778e2cd0
X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Apr 2025 17:44:27.6939
 (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: Gv9lsnH2CyOuAMx6DILsk3TFndfsHJiIyWylkC0Thzcrm4/LyClIxLiOBAaM7ELRdTfAfmxjSjsSniy3x03xnA==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: CH3PR02MB10010
X-Authority-Analysis: v=2.4 cv=HJ3DFptv c=1 sm=1 tr=0 ts=67f6b1fe cx=c_pps a=dbnGGe82Z6Ok/5ez5STjcQ==: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=9dl2-PFnBMld1VnH:21 a=frz4AuCg-hUA:10 a=_W_S_7VecoQA:10 a=isetazAf3aTA-zOkrMAI:22 a=DvbVbmnX2b-Y7U9ai7vN:22
X-Proofpoint-GUID: HtVe8VLnkSjRf0JdrA7iy_mBTrzaqh4q
X-Proofpoint-ORIG-GUID: HtVe8VLnkSjRf0JdrA7iy_mBTrzaqh4q
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 clxscore=1011 spamscore=0
 phishscore=0 mlxlogscore=393 lowpriorityscore=0 adultscore=0
 priorityscore=1501 impostorscore=0 mlxscore=0 suspectscore=0 bulkscore=0
 malwarescore=0 classifier=spam authscore=0 authtc=n/a authcc=
 route=outbound adjust=0 reason=mlx scancount=1 engine=8.19.0-2502280000
 definitions=main-2504090115
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/e5ff9605-80d6-4da9-a4ef-c6fa43bf4599%40bmc.com>
Precedence: bulk

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

Thanks for the answers.
All the 3 lines are, of course, uncommented for the test.
I am using Linux, socket is in /tmp, i see the .s files , but local trust s=
till does not connect.

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_e5ff960580d64da9a4efc6fa43bf4599bmccom_
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">Thanks for the answers. </div>
<div dir=3D"ltr">All the 3 lines are, of course, uncommented for the test. =
</div>
<div dir=3D"ltr">I am using Linux, socket is in /tmp, i see the .s files , =
but local trust still does not connect.
</div>
<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_e5ff960580d64da9a4efc6fa43bf4599bmccom_--