second db migration attempt

postgresql.log.2023-02-17-14

2023-02-17 14:38:39 UTC:10.0.84.9(46296):notifydb@notifydb:[12139]:ERROR: relation "awsdms_apply_exceptions" does not exist at character 22
2023-02-17 14:38:39 UTC:10.0.84.9(46296):notifydb@notifydb:[12139]:STATEMENT: SELECT COUNT(*) FROM "awsdms_apply_exceptions"
2023-02-17 14:39:41 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:40:03 UTC:10.0.84.9(53214):notifydb@notifydb:[14211]:ERROR: duplicate key value violates unique constraint "spatial_ref_sys_pkey"
2023-02-17 14:40:03 UTC:10.0.84.9(53214):notifydb@notifydb:[14211]:DETAIL: Key (srid)=(3819) already exists.
2023-02-17 14:40:03 UTC:10.0.84.9(53214):notifydb@notifydb:[14211]:CONTEXT: COPY spatial_ref_sys, line 1
2023-02-17 14:40:03 UTC:10.0.84.9(53214):notifydb@notifydb:[14211]:STATEMENT: COPY "public"."spatial_ref_sys" FROM STDIN WITH DELIMITER ',' CSV NULL 'attNULL' ESCAPE '\'
2023-02-17 14:40:27 UTC::@:[370]:LOG: checkpoint complete: wrote 103556 buffers (5.1%); 0 WAL file(s) added, 13 removed, 17 recycled; write=46.066 s, sync=0.100 s, total=46.427 s; sync files=241, longest=0.022 s, average=0.001 s; distance=1049995 kB, estimate=1049995 kB
2023-02-17 14:40:33 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:41:15 UTC::@:[370]:LOG: checkpoint complete: wrote 101377 buffers (5.0%); 0 WAL file(s) added, 0 removed, 16 recycled; write=41.035 s, sync=0.236 s, total=41.563 s; sync files=153, longest=0.136 s, average=0.002 s; distance=1048802 kB, estimate=1049876 kB
2023-02-17 14:41:18 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:41:57 UTC::@:[370]:LOG: checkpoint complete: wrote 109382 buffers (5.4%); 0 WAL file(s) added, 0 removed, 16 recycled; write=38.704 s, sync=0.166 s, total=39.141 s; sync files=76, longest=0.071 s, average=0.003 s; distance=1050543 kB, estimate=1050543 kB
2023-02-17 14:42:02 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:42:38 UTC::@:[370]:LOG: checkpoint complete: wrote 111548 buffers (5.5%); 0 WAL file(s) added, 0 removed, 16 recycled; write=35.945 s, sync=0.130 s, total=36.267 s; sync files=30, longest=0.072 s, average=0.005 s; distance=1046252 kB, estimate=1050114 kB
2023-02-17 14:42:44 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:43:14 UTC::@:[370]:LOG: checkpoint complete: wrote 112036 buffers (5.5%); 0 WAL file(s) added, 0 removed, 16 recycled; write=29.835 s, sync=0.190 s, total=30.108 s; sync files=24, longest=0.135 s, average=0.008 s; distance=1054158 kB, estimate=1054158 kB
2023-02-17 14:43:18 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:43:55 UTC::@:[370]:LOG: checkpoint complete: wrote 115487 buffers (5.7%); 0 WAL file(s) added, 0 removed, 16 recycled; write=36.091 s, sync=0.153 s, total=36.530 s; sync files=24, longest=0.109 s, average=0.007 s; distance=1043011 kB, estimate=1053043 kB
2023-02-17 14:43:56 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:44:30 UTC::@:[370]:LOG: checkpoint complete: wrote 106986 buffers (5.3%); 0 WAL file(s) added, 0 removed, 16 recycled; write=33.018 s, sync=0.226 s, total=33.539 s; sync files=21, longest=0.163 s, average=0.011 s; distance=1055579 kB, estimate=1055579 kB
2023-02-17 14:44:36 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:45:04 UTC::@:[370]:LOG: checkpoint complete: wrote 112895 buffers (5.6%); 0 WAL file(s) added, 0 removed, 16 recycled; write=27.796 s, sync=0.222 s, total=28.188 s; sync files=21, longest=0.142 s, average=0.011 s; distance=1048920 kB, estimate=1054913 kB
2023-02-17 14:45:08 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:45:37 UTC::@:[370]:LOG: checkpoint complete: wrote 116366 buffers (5.7%); 0 WAL file(s) added, 0 removed, 16 recycled; write=28.132 s, sync=0.109 s, total=28.389 s; sync files=23, longest=0.045 s, average=0.005 s; distance=1041128 kB, estimate=1053534 kB
2023-02-17 14:45:39 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:46:12 UTC::@:[370]:LOG: checkpoint complete: wrote 119934 buffers (5.9%); 0 WAL file(s) added, 0 removed, 16 recycled; write=32.073 s, sync=0.104 s, total=32.482 s; sync files=24, longest=0.046 s, average=0.005 s; distance=1049031 kB, estimate=1053084 kB
2023-02-17 14:46:18 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:46:53 UTC::@:[370]:LOG: checkpoint complete: wrote 120267 buffers (5.9%); 0 WAL file(s) added, 0 removed, 16 recycled; write=35.089 s, sync=0.091 s, total=35.285 s; sync files=21, longest=0.084 s, average=0.005 s; distance=1052287 kB, estimate=1053004 kB
2023-02-17 14:46:57 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:47:27 UTC::@:[370]:LOG: checkpoint complete: wrote 126827 buffers (6.2%); 0 WAL file(s) added, 0 removed, 16 recycled; write=30.315 s, sync=0.090 s, total=30.568 s; sync files=16, longest=0.050 s, average=0.006 s; distance=1043616 kB, estimate=1052066 kB
2023-02-17 14:47:33 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:48:00 UTC::@:[370]:LOG: checkpoint complete: wrote 131464 buffers (6.5%); 0 WAL file(s) added, 0 removed, 16 recycled; write=26.291 s, sync=0.243 s, total=26.766 s; sync files=17, longest=0.207 s, average=0.015 s; distance=1049874 kB, estimate=1051846 kB
2023-02-17 14:48:06 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:48:30 UTC::@:[370]:LOG: checkpoint complete: wrote 136259 buffers (6.7%); 0 WAL file(s) added, 0 removed, 16 recycled; write=24.005 s, sync=0.079 s, total=24.312 s; sync files=17, longest=0.057 s, average=0.005 s; distance=1051088 kB, estimate=1051771 kB
2023-02-17 14:48:37 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:48:58 UTC::@:[370]:LOG: checkpoint complete: wrote 139239 buffers (6.9%); 0 WAL file(s) added, 0 removed, 16 recycled; write=20.840 s, sync=0.107 s, total=21.095 s; sync files=17, longest=0.054 s, average=0.007 s; distance=1044634 kB, estimate=1051057 kB
2023-02-17 14:49:05 UTC::@:[370]:LOG: checkpoints are occurring too frequently (28 seconds apart)
2023-02-17 14:49:05 UTC::@:[370]:HINT: Consider increasing the configuration parameter "max_wal_size".
2023-02-17 14:49:05 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:49:24 UTC::@:[370]:LOG: checkpoint complete: wrote 143601 buffers (7.1%); 0 WAL file(s) added, 0 removed, 16 recycled; write=19.020 s, sync=0.204 s, total=19.358 s; sync files=19, longest=0.136 s, average=0.011 s; distance=1048757 kB, estimate=1050827 kB
2023-02-17 14:49:27 UTC::@:[370]:LOG: checkpoints are occurring too frequently (22 seconds apart)
2023-02-17 14:49:27 UTC::@:[370]:HINT: Consider increasing the configuration parameter "max_wal_size".
2023-02-17 14:49:27 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:49:49 UTC::@:[370]:LOG: checkpoint complete: wrote 146246 buffers (7.2%); 0 WAL file(s) added, 0 removed, 16 recycled; write=21.220 s, sync=0.129 s, total=21.561 s; sync files=19, longest=0.081 s, average=0.007 s; distance=1050053 kB, estimate=1050750 kB
2023-02-17 14:49:53 UTC::@:[370]:LOG: checkpoints are occurring too frequently (26 seconds apart)
2023-02-17 14:49:53 UTC::@:[370]:HINT: Consider increasing the configuration parameter "max_wal_size".
2023-02-17 14:49:53 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:50:10 UTC::@:[370]:LOG: checkpoint complete: wrote 148263 buffers (7.3%); 0 WAL file(s) added, 0 removed, 16 recycled; write=16.146 s, sync=0.165 s, total=16.541 s; sync files=18, longest=0.110 s, average=0.010 s; distance=1046933 kB, estimate=1050368 kB
2023-02-17 14:50:13 UTC::@:[370]:LOG: checkpoints are occurring too frequently (20 seconds apart)
2023-02-17 14:50:13 UTC::@:[370]:HINT: Consider increasing the configuration parameter "max_wal_size".
2023-02-17 14:50:13 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:50:29 UTC::@:[370]:LOG: checkpoint complete: wrote 149922 buffers (7.4%); 0 WAL file(s) added, 0 removed, 16 recycled; write=15.879 s, sync=0.156 s, total=16.280 s; sync files=20, longest=0.106 s, average=0.008 s; distance=1049645 kB, estimate=1050296 kB
2023-02-17 14:50:36 UTC::@:[370]:LOG: checkpoints are occurring too frequently (23 seconds apart)
2023-02-17 14:50:36 UTC::@:[370]:HINT: Consider increasing the configuration parameter "max_wal_size".
2023-02-17 14:50:36 UTC::@:[370]:LOG: checkpoint starting: xlog
2023-02-17 14:50:50 UTC::@:[370]:LOG: checkpoint complete: wrote 152851 buffers (7.5%); 0 WAL file(s) added, 0 removed, 16 recycled; write=14.113 s, sync=0.152 s, total=14.414 s; sync files=16, longest=0.148 s, average=0.010 s; distance=1049877 kB, estimate=1050254 kB
2023-02-17 14:50:54 UTC::@:[370]:LOG: checkpoints are occurring too frequently (18 seconds apart)
2023-02-17 14:50:54 UTC::@:[370]:HINT: Consider increasing the configuration parameter "max_wal_size".