Re: been away awhile but postgresql doesn't work for me now
Sherman Willden <sherman.willden@gmail.com>
From: Sherman Willden <sherman.willden@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-novice@lists.postgresql.org
Date: 2025-06-21T20:15:43Z
Lists: pgsql-novice
Thanks, I'll look into it. On Sat, Jun 21, 2025 at 2:05 PM 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 >