[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.sraoss.jp/pipermail/pgpool-general/attachments/20160418/fe786790/attachment.html>


More information about the pgpool-general mailing list