Re: BUG #5414: pg_dump failure from database 8.4.3 to 8.4.3

On 13/04/10 09:03, y.y.chen wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5414
> Logged by:          y.y.chen
> Email address:      yychen@clhs.tyc.edu.tw
> PostgreSQL version: 8.4.3
> Operating system:   XP  and  openSuSE 11.1
> Description:        pg_dump  failure  from database 8.4.3 to 8.4.3
> Details:
>
> pg_dump execute failure at dump from host to other host down in  all OS!
>
> pg_dump from 8.4.2 to 8.4.3 is OK!
> But pg_dump from 8.4.3 to 8.4.3 alway be failure!
> My SQL struction is
> "pg_dump -h192.168.0.17 -O db |psql -p5432 db"
>
> It can not do finished , It will be down !

Error message?

Does this happen with a blank database, or just with your `db' ?

If you pg_dump to a file instead of piping to psql, does that work?

If you then restore that file using psql, does that work?

--
Craig Ringer