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.kla...@aklaver.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.kla...@aklaver.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.kla...@aklaver.com >>> >>> >>> -- >>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-general >> >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
