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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sherman Willden <sherman(dot)willden(at)gmail(dot)com>
Cc: pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: been away awhile but postgresql doesn't work for me now
Date: 2025-06-21 20:05:36
Message-ID: 2791030.1750536336@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sherman Willden <sherman(dot)willden(at)gmail(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sherman Willden 2025-06-21 20:15:43 Re: been away awhile but postgresql doesn't work for me now
Previous Message Sherman Willden 2025-06-21 19:17:43 been away awhile but postgresql doesn't work for me now