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

[Ricardo Larrañaga]

Hey Tatsuo, thanks for the answer.

I am actually running pg_basebackup from the command line.

If i run it through pgpool (which listens in port 9999):

pg_basebackup -X stream -h myhost -p 9999 -D /var/lib/pgsql/9.5/data -U
replication -v -P

It fails with the mentioned descriptions.

If i run it to port 5432 (where postgresql backend listens) It works.

That is the reason i posted question in this list, i only seem to be having
this issue when going through pgpool.

Any pointers on how to troubleshoot the issue would be appreciated.


Thanks a lot!

Regards


On Apr 18, 2016 10:27 PM, "Tatsuo Ishii" <ishii at postgresql.org> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160418/ca529f29/attachment.html>