From: | aws backup <albatin(dot)saltanat(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dumpall: could not connect to database "template1": FATAL: |
Date: | 2016-11-13 13:51:38 |
Message-ID: | 748D78BC-2588-4D45-BF12-D094F42509E2@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Adrian,
thank you for the answer.
There is one password for the postgres database and one for the postgres user.
Both are not working somehow. Is there a way to look up the passwords? I saw in the documentation that there is a .pgpass file. But I can't find it.
I changed the auth method to trust for all users. This worked for now.
Thank you.
Best Regards,
Robert
> On 12 Nov 2016, at 23:31, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> On 11/12/2016 01:20 PM, aws backup wrote:
>> Hi,
>>
>> I try to make pg_dumpall backups from a PostgreSQL 9.5 server which is part of the DaVinci Resolve 12.5.3 App on a Mac OS X 10.11.6 system.
>>
>> Unfortunately I get following failure message:
>>
>> pg_dumpall: could not connect to database "template1": FATAL: password authentication failed for user "postgres"
>>
>> Maybe you can help me to solve this problem.
>
> Two choices:
>
> 1) Determine what the password is for the postgres user and provide it when you connect.
>
> 2) If you have access to the pg_hba.conf file create a access line that uses trust as the auth method for user postgres connect that way.
>
> https://www.postgresql.org/docs/9.5/static/auth-methods.html#AUTH-TRUST
>
>>
>> Thank you.
>>
>> Best Regards,
>> Robert
>>
>>
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | aws backup | 2016-11-13 13:51:54 | Re: pg_dumpall: could not connect to database "template1": FATAL: |
Previous Message | Aaron Lewis | 2016-11-13 11:54:36 | Trigram is slow when 10m rows |