[pgpool-general: 4644] Re: pg_basebackup with streaming replication option over pgpool

[Tatsuo Ishii]

I assume you invoke pg_basebackup from recovery_1st_stage_command.

If pg_basebackup succeeds when you invoke it by hand, there's possibility that:

- the difference between process owner. recovery_1st_stage_command is
  executed by the same owner as pgpool.

- wrong parameter passed to pg_basebackup. You can log the parameters
  for pg_basebackup by tweaking recovery_1st_stage_command.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 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