From: | Sherman Willden <sherman(dot)willden(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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:15:43 |
Message-ID: | CAFWhtBWaBreeSKtzzEL_-ozxhUrS77xU7aELEOse=qnroipiAA@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks, I'll look into it.
On Sat, Jun 21, 2025 at 2:05 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sherman Willden | 2025-06-22 03:59:24 | RE: Postgresql not acting like I think it should |
Previous Message | Tom Lane | 2025-06-21 20:05:36 | Re: been away awhile but postgresql doesn't work for me now |