Re: I can't seem to put the right combination of magic into the pg_hba and pg_ident files. - Mailing list pgsql-general

Tim Uckun wrote:
> psql -U postgres
> psql: FATAL:  Ident authentication failed for user "postgres"
>
>
> Obviously  I need to tell postgres to trust the user root when
> connected locally as postgres.
>
> How do I do that?
>


either create a postgres user named 'root' and give it superuser
privileges, or switch to a different method of authentication for LOCAL
users