pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Andreas Kretschmer <andreas@a-kretschmer.de>
To: pgsql-general@lists.postgresql.org
Subject: Re: strange behavior of pg_hba.conf file
Date: Wed, 22 Nov 2023 10:36:22 -0800
Message-ID: <d6fc59f5-1fdf-49e5-ae9f-da959fd1802f@aklaver.com> (raw)
In-Reply-To: <17bd5946-12d5-4907-baa9-dee368d34214@aklaver.com>
References: <CA+ONtZ7nMGfC23Gpgq7x9YtuP3YpqwXDQZNK6NdLTFn7e2fhrw@mail.gmail.com>
	<CANzqJaBkoU6SBeVvN3=VtFLgDLP1wTm7a_v9W6KYOr990sHRtg@mail.gmail.com>
	<CA+ONtZ63PUm0rEn_UxLwbv5Gg8a4RXgb2DQBOS9BZPSnd49ggg@mail.gmail.com>
	<CA+ONtZ7+383OhJ1Z37V5dJUo9ivU01HmhXZ_oL2hmkoSL-SEVg@mail.gmail.com>
	<d8a5560c-1363-426f-8144-fe3910ccf00c@aklaver.com>
	<CA+ONtZ7RZs8YvrXO68K=txJyHi4VGQVA6aYzuwT-6cN3642WRg@mail.gmail.com>
	<8758be84-0309-6ead-4d66-4d86a719f333@a-kretschmer.de>
	<17bd5946-12d5-4907-baa9-dee368d34214@aklaver.com>


On 11/22/23 10:01 AM, Adrian Klaver wrote:
>
>
> On 11/22/23 9:55 AM, Andreas Kretschmer wrote:
>>
>>
>> Am 22.11.23 um 18:44 schrieb Atul Kumar:
>>> I am giving this command
>>> psql -d postgres -U postgres -p 5432 -h localhost
>>> Then only I get that error.
>>
>> so localhost resolved to an IPv6 - address ...
>
>
> Yeah, you should take a look at:
>
> /etc/hosts
>
>
> In meantime include a  line for IPv6 in pg_hba.conf. where the address 
> would be:
>
> ::1/128

Or you could change


host all postgres 127.0.0.1/32 scram-sha-256


to


host all postgres localhost scram-sha-256

>
>

view thread (14+ messages)  latest in thread

Message-ID: <d6fc59f5-1fdf-49e5-ae9f-da959fd1802f@aklaver.com>
Permalink:  ../d6fc59f5-1fdf-49e5-ae9f-da959fd1802f@aklaver.com/
Also on:    postgresql.org/message-id/d6fc59f5-1fdf-49e5-ae9f-da959fd1802f@aklaver.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: adrian.klaver@aklaver.com, andreas@a-kretschmer.de
  Subject: Re: strange behavior of pg_hba.conf file
  In-Reply-To: <d6fc59f5-1fdf-49e5-ae9f-da959fd1802f@aklaver.com>
  References: <CA+ONtZ7nMGfC23Gpgq7x9YtuP3YpqwXDQZNK6NdLTFn7e2fhrw@mail.gmail.com> <CANzqJaBkoU6SBeVvN3=VtFLgDLP1wTm7a_v9W6KYOr990sHRtg@mail.gmail.com> <CA+ONtZ63PUm0rEn_UxLwbv5Gg8a4RXgb2DQBOS9BZPSnd49ggg@mail.gmail.com> <CA+ONtZ7+383OhJ1Z37V5dJUo9ivU01HmhXZ_oL2hmkoSL-SEVg@mail.gmail.com> <d8a5560c-1363-426f-8144-fe3910ccf00c@aklaver.com> <CA+ONtZ7RZs8YvrXO68K=txJyHi4VGQVA6aYzuwT-6cN3642WRg@mail.gmail.com> <8758be84-0309-6ead-4d66-4d86a719f333@a-kretschmer.de> <17bd5946-12d5-4907-baa9-dee368d34214@aklaver.com> <d6fc59f5-1fdf-49e5-ae9f-da959fd1802f@aklaver.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox