[pgpool-general: 4644] Re: pg_basebackup with streaming replication option over pgpool
ishii at postgresql.org
Tue Apr 19 10:27:43 JST 2016
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.
SRA OSS, Inc. Japan
> 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?
More information about the pgpool-general