[pgpool-hackers: 2369] Re: PostgreSQL 10 backward incompatibilities
ishii at sraoss.co.jp
Mon May 29 17:42:59 JST 2017
>> I think these calls are only made by pgpool-worker child process, So one
>> way could be to get the server version of each attached backend at the
>> child startup (SELECT current_setting('server_version_num')) and store the
>> version for each backend node in respective backend data structure.
>> And latter before sending the query we can construct the appropriate query
>> by looking at the version information for that backend.
> server_version_num appeared in PostgreSQL 8.2. Since those functions
> are only used in streaming replication, which first appeared in 9.6,
> we can safely your method. Nice idea!
Done. I have only modified pool_worker.c because those function calls
are only used in the streaming replication delay checking. Also this
is less invasive.
SRA OSS, Inc. Japan
More information about the pgpool-hackers