pg_basebackup: could not receive data from WAL stream

From: greigwise <greigwise(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_basebackup: could not receive data from WAL stream
Date: 2018-09-02 04:06:33
Message-ID: 1535861193579-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

On postgresql 10.5, my pg_basebackup is failing with this error:

pg_basebackup: could not receive data from WAL stream: server closed the
connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request

In the postgres log files, I'm seeing:

2018-09-02 00:57:32 UTC bkp_user 5b8b278c.11c3f [unknown] LOG: terminating
walsender process due to replication timeout

I'm running the following command right on the database server itself:

pg_basebackup -U repl -D /var/tmp/pg_basebackup_20180901 -Ft -z

It seems to be an intermittent problem.. I've had it fail or succeed about
50/50. I even bumped up the wal_sender_timeout to 2000. One notable thing
is that I'm running on an ec2 instance on AWS.

Any advice would be helpful.

Greig Wise

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Responses

Browse pgsql-general by date

  From Date Subject
Next Message greigwise 2018-09-02 04:14:11 Re: pg_basebackup: could not receive data from WAL stream
Previous Message Dave Peticolas 2018-09-02 02:40:54 Re: error in vacuum