MIME-Version: 1.0
From: Sherman Willden <sherman.willden@gmail.com>
Date: Sat, 21 Jun 2025 13:17:43 -0600
Message-ID: 
 <CAFWhtBU13ZFFxdC5s0OoFx4XwxK3p_Ng3qWq-EsgW79SuVk=-Q@mail.gmail.com>
Subject: been away awhile but postgresql doesn't work for me now
To: pgsql-novice@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e77b98063819d553"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFWhtBU13ZFFxdC5s0OoFx4XwxK3p_Ng3qWq-EsgW79SuVk%3D-Q%40mail.gmail.com>
Precedence: bulk

--000000000000e77b98063819d553
Content-Type: text/plain; charset="UTF-8"

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.

Some Background: I have used postgresql since somewhere arund 2000. I first
used UNIX in 1984 when I was in the USAF. I am now retired at 78 but after
retiring from the USAF I worked UNIX type postions at SUN Microsystems and
the Compaq to HP merger. I am presently using UBUNTU 24.04 on an HP host. I
haven't used postgresql since about 2023 and I thought it would be easy to
just do what I did befor. I have several notes I used for the last time I
used postgresql but they do not anwer the question I have. I have the
postgresql-16 pdfs. Did postgresql change from under me?

Other Information: I can log into postgres using sudo -u postgres -i

What I Want: Can someone tell me from the beginning how to establish my
first lo
gin to postgresql for both myself (sherman) and postgres?

Please let me know if you need more infomation.

Thank you;
Sherman

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

<div dir=3D"ltr">Basic complaint: polgresql 16 doesn&#39;t function as I th=
ink it should<br><br>First Error: postgresql psql server connection failed =
error<br><br>Second Error: Even after modifying /etc/postgresql/16/main/pg_=
hba.conf<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 to trust the s=
ystem is asking for postgres password.<br><br>Some Background: I have used =
postgresql since somewhere arund 2000. I first used UNIX in 1984 when I was=
 in the USAF. I am now retired at 78 but after retiring from the USAF I wor=
ked UNIX type postions at SUN Microsystems and the Compaq to HP merger. I a=
m presently using UBUNTU 24.04 on an HP host. I haven&#39;t used postgresql=
 since about 2023 and I thought it would be easy to just do what I did befo=
r. I have several notes I used for the last time I used postgresql but they=
 do not anwer the question I have. I have the postgresql-16 pdfs. Did postg=
resql change from under me?<br><br>Other Information: I can log into postgr=
es using sudo -u postgres -i<br><br>What I Want: Can someone tell me from t=
he beginning how to establish my first lo<br>gin to postgresql for both mys=
elf (sherman) and postgres?<br><br>Please let me know if you need more info=
mation.<br><br>Thank you;<br>Sherman<br><br></div>

--000000000000e77b98063819d553--