MIME-Version: 1.0
References: 
 <CAFWhtBU13ZFFxdC5s0OoFx4XwxK3p_Ng3qWq-EsgW79SuVk=-Q@mail.gmail.com>
 <2791030.1750536336@sss.pgh.pa.us>
In-Reply-To: <2791030.1750536336@sss.pgh.pa.us>
From: Sherman Willden <sherman.willden@gmail.com>
Date: Sat, 21 Jun 2025 14:15:43 -0600
Message-ID: 
 <CAFWhtBWaBreeSKtzzEL_-ozxhUrS77xU7aELEOse=qnroipiAA@mail.gmail.com>
Subject: Re: been away awhile but postgresql doesn't work for me now
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000591edb06381aa55e"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFWhtBWaBreeSKtzzEL_-ozxhUrS77xU7aELEOse%3DqnroipiAA%40mail.gmail.com>
Precedence: bulk

--000000000000591edb06381aa55e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thanks, I'll look into it.

On Sat, Jun 21, 2025 at 2:05=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Sherman Willden <sherman.willden@gmail.com> 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
>

--000000000000591edb06381aa55e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks, I&#39;ll look into it.=C2=A0</div><br><div class=
=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr=
">On Sat, Jun 21, 2025 at 2:05=E2=80=AFPM Tom Lane &lt;<a href=3D"mailto:tg=
l@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex">Sherman Willden &lt;<a href=3D"mailto:she=
rman.willden@gmail.com" target=3D"_blank">sherman.willden@gmail.com</a>&gt;=
 writes:<br>
&gt; Basic complaint: polgresql 16 doesn&#39;t function as I think it shoul=
d<br>
&gt; First Error: postgresql psql server connection failed error<br>
&gt; Second Error: Even after modifying /etc/postgresql/16/main/pg_hba.conf=
<br>
&gt;=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0to trust the sys=
tem is asking for postgres password.<br>
<br>
First question: did you restart the PG server, or at least do<br>
&quot;pg_ctl reload&quot;, after modifying pg_hba.conf?=C2=A0 It won&#39;t =
notice<br>
config file changes till you do.<br>
<br>
Second question: are you sure there&#39;s only one PG installation<br>
on the machine?=C2=A0 You might be connecting to a different installation<b=
r>
than you think you are.<br>
<br>
None of this stuff has changed greatly in the past couple of years.<br>
My guess is that you don&#39;t have the system configured quite the<br>
same as you did before.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div>

--000000000000591edb06381aa55e--