Re: pg_dumpall: could not connect to database "template1": FATAL:

Поиск
Список
Период
Сортировка
От aws backup
Тема Re: pg_dumpall: could not connect to database "template1": FATAL:
Дата
Msg-id 7FB1FECA-554A-4A12-9500-BFE652190BE1@gmail.com
обсуждение исходный текст
Ответ на Re: pg_dumpall: could not connect to database "template1": FATAL:  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: pg_dumpall: could not connect to database "template1": FATAL:
Список 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.marlowe@gmail.com> wrote:

On Sat, Nov 12, 2016 at 2:31 PM, Adrian Klaver
<adrian.klaver@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

OR you could use the -l switch and specify another db.

pg_dumpall -l mydbnamehere

В списке pgsql-general по дате отправления: