Re: Strange message from pg_receivexlog - Mailing list pgsql-general

From Fujii Masao
Subject Re: Strange message from pg_receivexlog
Date
Msg-id CAHGQGwG3Ova3qurV5Mi1jia0vhQWRYNEOGJA1j1kchdEojDr1Q@mail.gmail.com
Whole thread Raw
In response to Strange message from pg_receivexlog  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: Strange message from pg_receivexlog  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-general
On Tue, Aug 20, 2013 at 3:17 PM, Sergey Konoplev <gray.ru@gmail.com> wrote:
> 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@[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?

Is the value of replication_timeout sufficiently-larger than the status-interval
of pg_receivexlog?

Regards,

--
Fujii Masao


pgsql-general by date:

Previous
From: Don Parris
Date:
Subject: Locale Issue
Next
From: Tom Lane
Date:
Subject: Re: Bug in psql (\dd query)