Re: Strange message from pg_receivexlog

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Strange message from pg_receivexlog
Date: 2013-08-21 12:09:56
Message-ID: CAHGQGwG3Ova3qurV5Mi1jia0vhQWRYNEOGJA1j1kchdEojDr1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 20, 2013 at 3:17 PM, Sergey Konoplev <gray(dot)ru(at)gmail(dot)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(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?

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

Regards,

--
Fujii Masao

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-08-21 14:03:48 Re: Bug in psql (\dd query)
Previous Message Don Parris 2013-08-21 09:55:02 Locale Issue