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.zar...@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 db123 > > 2011/3/24 Guillaume Lelarge <guilla...@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). >> >> >> -- >> Guillaume >> http://www.postgresql.fr >> http://dalibo.com >> > >
