Re: Why pg_dump 'trust' authentication fails under root and works under another user?

Поиск
Список
Период
Сортировка
От Jaroslav Záruba
Тема Re: Why pg_dump 'trust' authentication fails under root and works under another user?
Дата
Msg-id AANLkTindQcU+LEoVOfkn2-AtTE=8fzPS746RTDdQDuNS@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why pg_dump 'trust' authentication fails under root and works under another user?  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: Why pg_dump 'trust' authentication fails under root and works under another user?  (Jaroslav Záruba <jaroslav.zaruba@gmail.com>)
Re: Why pg_dump 'trust' authentication fails under root and works under another user?  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: Why pg_dump 'trust' authentication fails under root and works under another user?  (Brett Parker <iDunno@sommitrealweird.co.uk>)
Список pgsql-admin
Дерево обсуждения
The command line is still the same, when executed under one user it does not ask for password, when executed under another (root that is) it does:
pg_dump --ignore-version --host=localhost --port=5432 --username=postgres --file="$BACKUP_FILE" --format=p --column-inserts --encoding=UTF-8 db123

2011/3/24 Guillaume Lelarge <guillaume@lelarge.info>
Le 24/03/2011 10:05, Jaroslav Záruba a écrit :
> My pg_hba.conf looks like this:
>
> local all     postgres        trust
> host all postgres 192.168.1.0/24 md5
> local all all ident
> host all all 127.0.0.1/32 md5
> host all all ::1/128 md5
>
>

Still lacks the complete pg_dump command lines (both of them, the good
and the bad one).


--

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Why pg_dump 'trust' authentication fails under root and works under another user?
Следующее
От: Jaroslav Záruba
Дата:
Сообщение: Re: Why pg_dump 'trust' authentication fails under root and works under another user?