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