public inbox for [email protected]
help / color / mirror / Atom feedbeen away awhile but postgresql doesn't work for me now
3+ messages / 2 participants
[nested] [flat]
* been away awhile but postgresql doesn't work for me now
@ 2025-06-21 19:17 Sherman Willden <[email protected]>
2025-06-21 20:05 ` Re: been away awhile but postgresql doesn't work for me now Tom Lane <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Sherman Willden @ 2025-06-21 19:17 UTC (permalink / raw)
To: [email protected]
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: been away awhile but postgresql doesn't work for me now
2025-06-21 19:17 been away awhile but postgresql doesn't work for me now Sherman Willden <[email protected]>
@ 2025-06-21 20:05 ` Tom Lane <[email protected]>
2025-06-21 20:15 ` Re: been away awhile but postgresql doesn't work for me now Sherman Willden <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2025-06-21 20:05 UTC (permalink / raw)
To: Sherman Willden <[email protected]>; +Cc: [email protected]
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: been away awhile but postgresql doesn't work for me now
2025-06-21 19:17 been away awhile but postgresql doesn't work for me now Sherman Willden <[email protected]>
2025-06-21 20:05 ` Re: been away awhile but postgresql doesn't work for me now Tom Lane <[email protected]>
@ 2025-06-21 20:15 ` Sherman Willden <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Sherman Willden @ 2025-06-21 20:15 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: [email protected]
Thanks, I'll look into it.
On Sat, Jun 21, 2025 at 2:05 PM Tom Lane <[email protected]> wrote:
> 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-06-21 20:15 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-06-21 19:17 been away awhile but postgresql doesn't work for me now Sherman Willden <[email protected]>
2025-06-21 20:05 ` Tom Lane <[email protected]>
2025-06-21 20:15 ` Sherman Willden <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox