public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Sherman Willden <[email protected]>
Cc: [email protected]
Subject: Re: been away awhile but postgresql doesn't work for me now
Date: Sat, 21 Jun 2025 16:05:36 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFWhtBU13ZFFxdC5s0OoFx4XwxK3p_Ng3qWq-EsgW79SuVk=-Q@mail.gmail.com>
References: <CAFWhtBU13ZFFxdC5s0OoFx4XwxK3p_Ng3qWq-EsgW79SuVk=-Q@mail.gmail.com>

Sherman Willden <[email protected]> writes:
> Basic complaint: polgresql 16 doesn't function as I think it should
> First Error: postgresql psql server connection failed error
> Second Error: Even after modifying /etc/postgresql/16/main/pg_hba.conf
>               to trust the system is asking for postgres password.

First question: did you restart the PG server, or at least do
"pg_ctl reload", after modifying pg_hba.conf?  It won't notice
config file changes till you do.

Second question: are you sure there's only one PG installation
on the machine?  You might be connecting to a different installation
than you think you are.

None of this stuff has changed greatly in the past couple of years.
My guess is that you don't have the system configured quite the
same as you did before.

			regards, tom lane

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 using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: been away awhile but postgresql doesn't work for me now
  In-Reply-To: <[email protected]>

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

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