[pgpool-general: 4643] pg_basebackup with streaming replication option over pgpool
Ricardo Larrañaga
ricardo.larranaga at gmail.com
Tue Apr 19 02:44:03 JST 2016
Hello Guys:
I was wondering if anyone here has tried to use pg_basebackup with the
-X=stream option over pgpool.
I a
I am using postgresql 9.5.2 with pgpool 3.5.1 an issue where when i try to
do this, pg_basebackup hangs on the following line of the progress report:
pg_basebackup: waiting for background process to finish streaming ...
and then it just quits with the following errors:
pg_basebackup: unexpected termination of replication stream: FATAL: unable
to read data from DB node 0
DETAIL: EOF encountered with backend
pg_basebackup: child process exited with error 1
from the backend point of view, i see the following:
< 2016-04-18 14:34:33.376 ADT >LOG: terminating walsender process due to
replication timeout
< 2016-04-18 14:34:33.384 ADT >ERROR: syntax error
pg_basebackup works ok with the fetch option (But i would like to avoid
using it, as it would require for me to also implement PITR, or to stop
transactions to the DB)
pg_basebackup works ok if i connect directly to the backend
Any ideas how i could troubleshoot this?
Thanks.
Regards
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20160418/fe786790/attachment.htm>
More information about the pgpool-general
mailing list