error

This is a multi-part message in MIME format.

------_=_NextPart_001_01CAC702.CB163833
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Ho folks,





Was wandering if anybody can point me in the right direction. I am
using walmgr to move WAL files from primary to stand by server.



And I keep getting this in my log files:



rsync: connection unexpectedly closed (0 bytes received so far) [sender]

rsync error: error in rsync protocol data stream (code 12) at io.c(453)
[sender=3D2.6.9]

2010-03-18 21:20:22,194 10972 CRITICAL rsync exec failed, res=3D12

2010-03-18 21:20:22,197 10972 INFO got SystemExit(1), exiting

LOG: archive command failed with exit code 1

DETAIL: The failed archive command was:
/skytools-2.1.11/python/walmgr.py /skytools-2.1.11/python/wal-master.ini
xarchive pg_xlog/000000010000000000000000 00000001000000$

Host key verification failed.





I know there is nothing wrong with my host key as I can move between the
servers with out any issues.



Thanks,


____________________________________=0D
The information contained in this transmission may contain privileged =0D
and confidential information. It is intended only for the use of the =0D
person(s) named above. If you are not the intended recipient, you are =0D
hereby notified that any review, dissemination, distribution or =0D
duplication of this communication is strictly prohibited. If you are =0D
not the intended recipient, please contact the sender by reply email =0D
and destroy all copies of the original message.

------_=_NextPart_001_01CAC702.CB163833
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV=3D"Content-Type" CONTENT=
=3D"text/html; charset=3Dus-ascii"><meta name=3DGenerator content=3D"Micros=
oft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
[at] font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
..MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
[at] page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--></head><body lang=3DEN-US link=3Dblue vli=
nk=3Dpurple><div class=3DWordSection1><p class=3DMsoNormal><span style=3D'c=
olor:#1F497D'>Ho folks,<o:p></o:p></span></p><p class=3DMsoNormal><span sty=
le=3D'color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><span=
style=3D'color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><=
span style=3D'color:#1F497D'>Was wandering if anybody can point me in the r=
ight direction.  I am using walmgr to move WAL files from primary to s=
tand by server.<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'co=
lor:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><span style=
=3D'color:#1F497D'>And I keep getting this in my log files:<o:p></o:p></spa=
n></p><p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p> </o:p><=
/span></p><p class=3DMsoNormal><span style=3D'color:#1F497D'>rsync: connect=
ion unexpectedly closed (0 bytes received so far) [sender]<o:p></o:p></span=
></p><p class=3DMsoNormal><span style=3D'color:#1F497D'>rsync error: error =
in rsync protocol data stream (code 12) at io.c(453) [sender=3D2.6.9]<o:p><=
/o:p></span></p><p class=3DMsoNormal><span style=3D'color:#1F497D'>2010-03-=
18 21:20:22,194 10972 CRITICAL rsync exec failed, res=3D12<o:p></o:p></span=
></p><p class=3DMsoNormal><span style=3D'color:#1F497D'>2010-03-18 21:20:22=
,197 10972 INFO got SystemExit(1), exiting<o:p></o:p></span></p><p class=3D=
MsoNormal><span style=3D'color:#1F497D'>LOG:  archive command failed w=
ith exit code 1<o:p></o:p></span></p><p class=3DMsoNormal><span style=3D'co=
lor:#1F497D'>DETAIL:  The failed archive command was: /skytools-2.1.11=
/python/walmgr.py /skytools-2.1.11/python/wal-master.ini xarchive pg_xlog/0=
00000010000000000000000 00000001000000$<o:p></o:p></span></p><p class=3DMso=
Normal><span style=3D'color:#1F497D'>Host key verification failed.<o:p></o:=
p></span></p><p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p> =
</o:p></span></p><p class=3DMsoNormal><span style=3D'color:#1F497D'><o:p>&n=
bsp;</o:p></span></p><p class=3DMsoNormal><span style=3D'color:#1F497D'>I k=
now there is nothing wrong with my host key as I can move between the serve=
rs with out any issues.<o:p></o:p></span></p><p class=3DMsoNormal><span sty=
le=3D'color:#1F497D'><o:p> </o:p></span></p><p class=3DMsoNormal><span=
style=3D'color:#1F497D'>Thanks,<o:p></o:p></span></p></div>
</body></html>
------_=_NextPart_001_01CAC702.CB163833--
Vitaly Burshteyn [ Fr, 19 März 2010 02:23 ] [ ID #2035704 ]

Re: error

--=-p3+cdP+8PUujpRsKRNib
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, 2010-03-18 at 21:23 -0400, Vitaly Burshteyn wrote:
> Host key verification failed.
>
> I know there is nothing wrong with my host key as I can move between
> the servers with out any issues.

Host key !=3D ssh key.

You can easily reproduce this issue by trying to ssh from master to
slave server as user postgres (or whatever). If you are sure that
nothing is wrong, feel free to delete the related entry in
~/ssh/known_hosts file, and ssh to the slave server manually to test.
--
Devrim G=C3=9CND=C3=9CZ
PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

--=-p3+cdP+8PUujpRsKRNib
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEABECAAYFAkujG2kACgkQtl86P3SPfQ6z5wCgzZP/bJVHUGtVAnklIj0t T4hv
VH0AoNxCkgnTXe+11/0wKJH2PvnJM40R
=j/Hk
-----END PGP SIGNATURE-----

--=-p3+cdP+8PUujpRsKRNib--
devrim [ Fr, 19 März 2010 07:36 ] [ ID #2035706 ]
Datenbanken » gmane.comp.db.postgresql.admin » error

Vorheriges Thema: Postgesql and SSL
Nächstes Thema: WHo is locking me?