Hi, now I have another problem. Sorry I am an absolute beginner. When I restore the dumpall backup with
"psql -f infile postgres" I get lot of errors > "already exists" and the database is not restored to the point of the backup. I mean after I made the backup I changed something and I expected that this change is undone after I restore the backup which did not happen. Looks for me like nothing was restored … ? Thank you for your help. Regards, Robert > On 13 Nov 2016, at 00:37, Scott Marlowe <scott.marl...@gmail.com > <mailto:scott.marl...@gmail.com>> wrote: > > On Sat, Nov 12, 2016 at 2:31 PM, Adrian Klaver > <adrian.kla...@aklaver.com <mailto: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 >> <https://www.postgresql.org/docs/9.5/static/auth-methods.html#AUTH-TRUST> > > OR you could use the -l switch and specify another db. > > pg_dumpall -l mydbnamehere