Re: Why pg_dump 'trust' authentication fails under root and works under another user?

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Jaroslav Záruba <jaroslav(dot)zaruba(at)gmail(dot)com>
Cc: PostgreSQL - mailing list <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Why pg_dump 'trust' authentication fails under root and works under another user?
Date: 2011-03-24 08:56:56
Message-ID: 4D8B0758.8020707@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Please, answer to the list.

Le 24/03/2011 09:13, Jaroslav Záruba a écrit :
> Yes, it is the password for PostgreSQL.
>
> pg_dump: [archiver (db)] connection to database "db123" failed: FATAL:
> password authentication failed for user "postgres"
> FATAL: password authentication failed for user "postgres"
>

The error message says the authentication method used isn't trust. Can
you tell us the complete content of your pg_hba.conf (without the
comments of course), and the exact command lines (the one that work and
the one that doesn't work).

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jaroslav Záruba 2011-03-24 09:05:00 Re: Why pg_dump 'trust' authentication fails under root and works under another user?
Previous Message lst_hoe02 2011-03-24 08:32:45 Re: About migration to Postgre