Re: pg_dump/pg_dumpall

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема Re: pg_dump/pg_dumpall
Дата
Msg-id 290552.38390.qm@web31806.mail.mud.yahoo.com
обсуждение исходный текст
Ответ на pg_dump/pg_dumpall  ("Andrew C. Uselton" <acuselton@lbl.gov>)
Список pgsql-novice
--- "Andrew C. Uselton" <acuselton@lbl.gov> wrote:

> Greetings,
>   I was just trying to get a live backup of my database and had the following error:
>
> uselton]# pg_dumpall   > /tmp/osp5_pgsql.dump
> Password:
> pg_dumpall: could not connect to database "template1": FATAL:  Password authentication failed
> for user "root"
>

Actually, if you don't specify a DB username, pg_dumpall uses the calling OS username as a
default.  It this user doesn't exist, or you enter the wrong password for the DB you will get this
error.
Regards,
Richard Broersma Jr.



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

Предыдущее
От: "Andrew C. Uselton"
Дата:
Сообщение: pg_dump/pg_dumpall
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: pg_dump/pg_dumpall