Feedback-ID: i76984098:Fastmail
Message-ID: <08c7b49e-265a-410a-b0fd-0f4bcdc4fb02@aklaver.com>
Date: Wed, 9 Apr 2025 10:47:03 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: [EXTERNAL] Re: Cannot connect local with ttrust (pg_upgrade
 assumes it)
To: "Abraham, Danny" <danny_abraham@bmc.com>,
 Francisco Olarte <folarte@peoplecall.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <SA1PR02MB96986CA15EEF976BFE16D2F28EB42@SA1PR02MB9698.namprd02.prod.outlook.com>
 <CA+bJJby+nA8OVs7AZKgGBX2Dx3ApvhEceWtFiq97crkiER2A=Q@mail.gmail.com>
 <e5ff9605-80d6-4da9-a4ef-c6fa43bf4599@bmc.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <e5ff9605-80d6-4da9-a4ef-c6fa43bf4599@bmc.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/08c7b49e-265a-410a-b0fd-0f4bcdc4fb02%40aklaver.com>
Precedence: bulk


On 4/9/25 10:44 AM, Abraham, Danny wrote:
> Thanks for the answers.
> All the 3 lines are, of course, uncommented for the test.

Then provide the actual configuration you are working with.

> I am using Linux, socket is in /tmp, i see the .s files , but local 
> trust still does not connect.

Provide:

a) The connection string you are using.

b) The error you get.

> 
> 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.

-- 
Adrian Klaver
adrian.klaver@aklaver.com