[ERROR] invalid input syntax for type timestamp with time zone

Question

[ERROR] invalid input syntax for type timestamp with time zone

seunofk opened this issue 2 years ago · 0 comments

hello.

After configuring repmgr, an error occurs on the primary server.

It seems to be synchronizing, but please let me know what kind of error this is.

PostgreSQL Version : 10.8
Repmgr Version : 5.2.1

ERROR: [2022-12-05 09:00:19.820 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:21.847 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:23.873 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:25.900 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:27.929 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:29.956 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:31.985 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:34.013 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:36.040 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:38.071 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:40.099 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:42.130 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:44.158 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:46.187 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:48.217 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:50.248 KST] [10.147.26.178 (33342)] [postgresql] [repagr] [repagr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:52.278 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:54.306 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:56.338 KST] [10.147.26.178 (33342)] [postgresql] [repagr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:00:58.368 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:00.401 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:02.440 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:04.473 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:06.502 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:08.534 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:10.564 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:12.592 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [zepmgz] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:14.619 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:16.649 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repagr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:18.676 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:20.703 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:22.734 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:24.762 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:26.790 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:28.818 KST] [10.147.26.178 (33342)] [postgresql] [repagr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:30.845 KST] [10.147.26.178 (33342)] [postgresql] [repagr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:32.874 KST] [10.147.26.178 (33342)] [postgresql] [repagr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:34.905 KST] [10.147.26.178 (33342)1 [postgresql] [repagr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401
ERROR: [2022-12-05 09:01:36.933 KST] [10.147.26.178 (33342)] [postgresql] [repmgr] [repmgr] [14195] [22007] invalid input syntax for type timestamp with time zone: "" at character 401