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 10:47:43
Message-ID: 4D8B214F.4060406@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Le 24/03/2011 11:32, Jaroslav Záruba a écrit :
> You nailed it! :)
>
> My regular user has .pgpass, root does not.
> When I remove the --host (and --port) arguments it works like charm. :)
>
> Thanks a lot, Guillaume!
>

You're welcome :)

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stevie 2011-03-24 12:39:22 ERROR: could not access status of transaction
Previous Message Guillaume Lelarge 2011-03-24 10:25:13 Re: Why pg_dump 'trust' authentication fails under root and works under another user?