Thread: BUG #5433: pg_dump (8.4.3) copy database failure!

The following bug has been logged online:

Bug reference:      5433
Logged by:          y.y.Chen
Email address:      yychen@clhs.tyc.edu.tw
PostgreSQL version: 8.4.3
Operating system:   OpenSuSE  and XP
Description:        pg_dump (8.4.3)  copy database  failure!
Details:

Server A:Ver 8.4.3
Server B:Ver 8.4.2

pg_dump in A=> pg_dump -h A  db > file      =>failure
pg_dump in B => pg_dump -h A  db > file      =>success

While dump failure and pg_dump can't run to over !
It's possible then  pg_dump fail at field with character varying(480)!

On Wed, Apr 21, 2010 at 11:21 PM, y.y.Chen <yychen@clhs.tyc.edu.tw> wrote:
>
>
> pg_dump in A=3D> pg_dump -h A =C2=A0db > file =C2=A0 =C2=A0 =C2=A0=3D>fai=
lure
> pg_dump in B =3D> pg_dump -h A =C2=A0db > file =C2=A0 =C2=A0 =C2=A0=3D>su=
ccess
>

and what was the error?
are you sure pg_hba.conf allow host connections from A to A for that
database and user?

--=20
Atentamente,
Jaime Casanova
Soporte y capacitaci=C3=B3n de PostgreSQL
Asesor=C3=ADa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

---------- Forwarded message ----------
From: =E9=99=B3=E8=A3=95=E8=80=80 <yychen@clhs.tyc.edu.tw>
Date: 2010/4/22
Subject: Re: [BUGS] BUG #5433: pg_dump (8.4.3) copy database failure!
To: Jaime Casanova <jcasanov@systemguards.com.ec>


=E6=96=BC 2010/4/22 =E4=B8=8B=E5=8D=88 12:56, Jaime Casanova =E6=8F=90=E5=
=88=B0:

On Wed, Apr 21, 2010 at 11:21 PM, y.y.Chen <yychen@clhs.tyc.edu.tw> wrote:


pg_dump in A=3D> pg_dump -h A =C2=A0db > file =C2=A0 =C2=A0 =C2=A0=3D>failu=
re
pg_dump in B =3D> pg_dump -h A =C2=A0db > file =C2=A0 =C2=A0 =C2=A0=3D>succ=
ess



and what was the error?


No any=C2=A0 message , because of=C2=A0 session of pg-dump can not return to
command-line ! It is hang up !
But there is=C2=A0 a message only =C2=A0 when run in Server of data sender :
=C2=A0 =C2=A0 =C2=A0 "pg_dump =C2=A0 -h localhostVer8.4.3=C2=A0 =C2=A0 db=
=C2=A0=C2=A0 | psql -h RemoteHost_Ver8.4.3 db "
This messages is " could not receive data from client : connection be
reset by remote !"

database and user?


pg_hba.conf is all ok=C2=A0 that=C2=A0 Server updated from
8.0->8.1->8.2->8.3->8.4.2=C2=A0 to 8.4.3!





--
Atentamente,
Jaime Casanova
Soporte y capacitaci=C3=B3n de PostgreSQL
Asesor=C3=ADa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157