Re: pg_dumpall: could not connect to database "template1": FATAL:

Hi Adrian,

I assume that the postgres database password is the one which is shown in the DaVinci connect database window.

user: postgres
password: DaVinci

But if I work in the Terminal and change the user "sudo su - postgres" I have to use my admin password.
From the DaVinci manual:

> • Make sure you log in as a user with Admin privileges, then open the Terminal application, located in the /Applications/Utilities folder, and open up the postgres environment for editing by typing:
>
> sudo su - postgres
>
> • At the prompt, type that computer’s administrator password and press return.
>
> • When the “postgres$” prompt appears, you’ll create a backup of the “pg_hba.conf” setup
>
> le for safety by typing:

Therefore I assumed that the postgres user has the same password as my admin account. But maybe I am wrong with these assumptions.

> That is optional and I sort of doubt the application using one.

You think DaVinci is not using any password … ?

Thank you.
Robert

> On 13 Nov 2016, at 17:57, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> On 11/13/2016 05:51 AM, aws backup wrote:
>> Hi Adrian,
>>
>> thank you for the answer.
>> There is one password for the postgres database and one for the postgres user.
>
> How are you determining this?
>
> More to the point are you talking about the application(DaVinci Resolve) or the database itself?
>
>> 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.
>
> That is optional and I sort of doubt the application using one.
>
>>
>> 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
>>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>