Skip site navigation (1) Skip section navigation (2)

Strange message from pg_receivexlog

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Strange message from pg_receivexlog
Date: 2013-08-20 06:17:43
Message-ID: CAL_0b1t65bFBm3RKpHtFi57pNhCx7VwvTiDfS7S59cvpRip5Xw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi all,

My WAL archiving script based on pg_receivexlog reported the following
error several days ago (just ignore everything before
'pg_receivexlog', it's a message my script generates).

Thu Aug 15 18:33:09 MSK 2013 ERROR archive_wal.sh: Problem occured
during WAL archiving: pg_receivexlog: could not send feedback packet:
server closed the connection unexpectedly

At the same time postgres reported this error in log:

2013-08-15 18:32:51 MSK 30945 postgres(at)[unknown] from [local]
[vxid:53/0 txid:0] [streaming 2A97/6FA48000] LOG:  terminating
walsender process due to replication timeout

Both pg_receivexlog and postgres run at the same machive,
pg_receivexlog connects to postgres locally. /var/log/messages has
absolutely nothing about it. I also have a hot standby on another
machine connecting to the same master, but there is nothing strange in
its logs either.

Any thoughts what it was?

-- 
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray(dot)ru(at)gmail(dot)com


Responses

pgsql-general by date

Next:From: Magnus HaganderDate: 2013-08-20 09:10:53
Subject: Re: Strange message from pg_receivexlog
Previous:From: BladeOfLight16Date: 2013-08-20 03:41:38
Subject: Re: Denormalized field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group