Dear Kato-san, Thank you for reviewing!
> Thank you for sending the patches! > I confirmed that they can be compiled and tested successfully on CentOS > 8. Thanks! > + { > + {"remote_servers_connection_check_interval", PGC_USERSET, > CONN_AUTH_SETTINGS, > + gettext_noop("Sets the time interval between checks > for > disconnection of remote servers."), > + NULL, > + GUC_UNIT_MS > + }, > + &remote_servers_connection_check_interval, > + 0, 0, INT_MAX, > + }, > > If you don't use check_hook, assign_hook and show_hook, you should > explicitly write "NULL, NULL, NULL", as show below. Yeah I forgot the line. Fixed. > + ereport(ERROR, > + > errcode(ERRCODE_CONNECTION_FAILURE), > + errmsg("Postgres foreign server %s > might be down.", > + > server->servername)); > > According to [1], error messages should start with a lowercase letter > and not use a period. > Also, along with the rest of the code, it is a good idea to enclose the > server name in double quotes. I confirmed the postgres error-reporting policy and fixed to follow that. How do you think? Attached are the latest version. Best Regards, Hayato Kuroda FUJITSU LIMITED
<<attachment: 20211124.zip>>
v02_add_checking_infrastracture.patch
Description: v02_add_checking_infrastracture.patch
v02_add_helth_check_for_postgres_fdw.patch
Description: v02_add_helth_check_for_postgres_fdw.patch