[pgpool-general: 8540] Re: pgpool version 4.4 with postgres version 14

[Menna Sheta]

Hello,

currently we are using pgpool version 4.4 with postgres version 14 but the
pgpool has issue in get replication status as per below error from postgres
logs:



*pgpool at postgres LOG:  could not receive data from client: Connection reset
by peer2023-01-09 11:00:16.890 EET [2206798] pgpool at postgres ERROR:
 integer out of range2023-01-09 11:00:16.890 EET [2206798] pgpool at postgres
STATEMENT:  SELECT application_name, state, sync_state,(EXTRACT(EPOCH FROM
replay_lag)*1000000)::integer FROM pg_stat_replication*

so, is there any solution or workaround for this issue?

Thanks in advance.
Regards,
Menna Sheta

On Mon, 9 Jan 2023 at 11:05, Menna Sheta <mennasheta2020 at gmail.com> wrote:

> Hello,
>
> currently we are using pgpool version 4.4 with postgres version 14 but the
> pgpool has issue in get replication status as per below error from postgres
> logs:
>
>
>
> *pgpool at postgres LOG:  could not receive data from client: Connection
> reset by peer2023-01-09 11:00:16.890 EET [2206798] pgpool at postgres ERROR:
>  integer out of range2023-01-09 11:00:16.890 EET [2206798] pgpool at postgres
> STATEMENT:  SELECT application_name, state, sync_state,(EXTRACT(EPOCH FROM
> replay_lag)*1000000)::integer FROM pg_stat_replication*
>
> so, is there any solution or workaround for this issue?
>
> Thanks in advance.
> Regards,
> Menna Sheta
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230112/4fad9f01/attachment.htm>