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 | AANLkTinXpxHJV4eVv0idj2Wir6F0T=yC=Ro3Ox4wmT2J@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Why pg_dump 'trust' authentication fails under root and works under another user? (Jaroslav Záruba <jaroslav.zaruba@gmail.com>) |
| Список | pgsql-admin |
This is what pops up in postgres log whenever I run the command under root, just when I get prompted for password:
--
could not receive data from client: Connection reset by peer
--
2011/3/24 Jaroslav Záruba <jaroslav.zaruba@gmail.com>
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 db1232011/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:Still lacks the complete pg_dump command lines (both of them, the good
>
> 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
>
>
and the bad one).
--
В списке pgsql-admin по дате отправления: