From: | aws backup <albatin(dot)saltanat(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dumpall: could not connect to database "template1": FATAL: |
Date: | 2016-11-13 13:51:54 |
Message-ID: | 7FB1FECA-554A-4A12-9500-BFE652190BE1@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)marlowe(at)gmail(dot)com <mailto:scott(dot)marlowe(at)gmail(dot)com>> wrote:
>
> On Sat, Nov 12, 2016 at 2:31 PM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto: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 <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 | Oleg Bartunov | 2016-11-13 14:04:14 | Re: Trigram is slow when 10m rows |
Previous Message | aws backup | 2016-11-13 13:51:38 | Re: pg_dumpall: could not connect to database "template1": FATAL: |