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
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 |