From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | aws backup <albatin(dot)saltanat(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall: could not connect to database "template1": FATAL: |
Date: | 2016-11-12 22:37:26 |
Message-ID: | CAOR=d=2mySeSswFyWK=mOY9pV9Zx6WT+x3X5kxmzpiSSV_w-Mg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, Nov 12, 2016 at 2:31 PM, 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
OR you could use the -l switch and specify another db.
pg_dumpall -l mydbnamehere
From | Date | Subject | |
---|---|---|---|
Next Message | otar shavadze | 2016-11-13 01:33:52 | Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists |
Previous Message | Adrian Klaver | 2016-11-12 21:31:56 | Re: pg_dumpall: could not connect to database "template1": FATAL: |