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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Tim Uckun <timuckun(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: I can't seem to put the right combination of magic into the pg_hba and pg_ident files.
Date: 2009-11-09 07:04:33
Message-ID: 4AF7BF01.8030705@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Uwe Schroeder 2009-11-09 07:38:28 virtualidx exclusive lock
Previous Message Tim Uckun 2009-11-09 06:48:49 Re: I can't seem to put the right combination of magic into the pg_hba and pg_ident files.