been away awhile but postgresql doesn't work for me now

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Sherman Willden <[email protected]>
To: [email protected]
Subject: been away awhile but postgresql doesn't work for me now
Date: Sat, 21 Jun 2025 13:17:43 -0600
Message-ID: <CAFWhtBU13ZFFxdC5s0OoFx4XwxK3p_Ng3qWq-EsgW79SuVk=-Q@mail.gmail.com> (raw)

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

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]
  Subject: Re: been away awhile but postgresql doesn't work for me now
  In-Reply-To: <CAFWhtBU13ZFFxdC5s0OoFx4XwxK3p_Ng3qWq-EsgW79SuVk=-Q@mail.gmail.com>

* 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