| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | aws backup <albatin(dot)saltanat(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dumpall: could not connect to database "template1": FATAL: |
| Date: | 2016-11-12 21:31:56 |
| Message-ID: | ab246bcc-7426-e296-c8ef-6be747427287@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2016-11-12 22:37:26 | Re: pg_dumpall: could not connect to database "template1": FATAL: |
| Previous Message | aws backup | 2016-11-12 21:20:25 | pg_dumpall: could not connect to database "template1": FATAL: |