From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | franz(at)kalibrr(dot)com |
Subject: | BUG #15073: Bad error message for when pg_basebackup fails due to incorrect wal_level |
Date: | 2018-02-19 02:23:10 |
Message-ID: | 151900699070.1391.5862985411054912618@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15073
Logged by: Franz Beltran
Email address: franz(at)kalibrr(dot)com
PostgreSQL version: 9.6.6
Operating system: Linux
Description:
Hi,
I was trying to perform a repmgr standby clone but it gets stuck on
pg_basebackup:
$ /usr/bin/repmgr -h <primary_DB_server_IP> -D /var/lib/postgresql/9.6/main
-d repmgr -U repmgr --upstream-node-id=<primary_DB_node_ID> -f
/etc/postgresql/9.6/main/repmgr.conf standby clone -v --log-level DEBUG
NOTICE: using provided configuration file
"/etc/postgresql/9.6/main/repmgr.conf"
NOTICE: destination directory "/var/lib/postgresql/9.6/main" provided
...
...
...
HINT: this may take some time; consider using the -c/--fast-checkpoint
option
INFO: executing:
pg_basebackup -l "repmgr base backup" -D /var/lib/postgresql/9.6/main -h
<primary_DB_server_IP> -p <primary_DB_server_port> -U repmgr -X stream
Upon checking the logs on the upstream server, the following error is
encountered:
user=repmgr,db=[unknown],app=pg_basebackup,client=<standby_IP>LOG: could
not send data to client: Broken pipe
user=repmgr,db=[unknown],app=pg_basebackup,client=<standby_IP>ERROR: base
backup could not send data, aborting backup
user=repmgr,db=[unknown],app=pg_basebackup,client=<standby_IP>FATAL:
connection to client lost
After some tinkering, we found that updating the following line in the
primary's postgresql.conf from:
wal_level = archive
to:
wal_level = hot_standby
resolves the issue.
It just seems like a bad user experience and a more meaningful error message
would've helped.
Thanks!
--
Franz Beltran
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-02-19 03:15:24 | Re: BUG #15073: Bad error message for when pg_basebackup fails due to incorrect wal_level |
Previous Message | Peter Geoghegan | 2018-02-18 18:06:29 | Re: [BUGS] BUG #14870: wrong query results when using WITH with UPDATE |