Re: BUG #5414: pg_dump failure from database 8.4.3 to 8.4.3 - Mailing list pgsql-bugs

From Craig Ringer
Subject Re: BUG #5414: pg_dump failure from database 8.4.3 to 8.4.3
Date
Msg-id 4BC42798.7040008@postnewspapers.com.au
Whole thread Raw
In response to BUG #5414: pg_dump failure from database 8.4.3 to 8.4.3  ("y.y.chen" <yychen@clhs.tyc.edu.tw>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: "Kenaniah Cerny"
Date:
Subject: BUG #5417: intarray adds <@ operator which breaks infromation_schema.referential_constraints
Next
From: Magnus Hagander
Date:
Subject: Re: Possible alpha5 SR bug