Search Postgresql Archives

Re: FATAL: password authentication failed for user "postgres"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Nov 3, 2011 at 9:02 AM, Sabn Coanda <s.coanda@xxxxxxxxxxxxx> wrote:
> Hi,
>
> I am using trust authentication since some years, but I need now to
> authenticate the user for a specific application when connect to postgresql
> database. I found "trust" ignores the password, so I changed it in
> pg_hba.conf to "password".
>

You should probably switch this to md5. It gives the same basic
functionality, but it's more secure.

> My application is working now, but I have problems running the usual
> maintenance scripts. For instance, when I am running pg_dump with postgres
> user, it requires the password. The problem is it doesn't accept the
> password I used in pgAdmin to connect to the same database for the same
> database user.
>
> What is wrong ?
>
> My pg_hba.conf looks like:
> local all all password
> host all all 127.0.0.1/32 password
>
> The command I am running is:
> pg_dump <my_db_name> -F c -v -X disable-triggers -U postgres -h 127.0.0.1 -p
> 5432 -f ./test.backup
>

Does pgadmin also connect via 127.0.0.1? What happens if you dump via
the local socket? Also, do you get an error for pg_dump, or does it
just prompt for a password that it wont accept what you submit?

Robert Treat
conjecture: xzilla.net
consulting: omniti.com

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux