that doesn’t work. Here is the error log I got under pg_log folder. Let me know if you need further info.
Thanks and Regards,
Henry
[root@sen2cap pg_log]# ll
total 740
-rw-------. 1 postgres postgres 143642 Jun 5 23:35 postgresql-Fri.log
-rw-------. 1 postgres postgres 88395 Jun 8 13:38 postgresql-Mon.log
-rw-------. 1 postgres postgres 44610 Jun 6 22:22 postgresql-Sat.log
-rw-------. 1 postgres postgres 87733 Jun 7 23:23 postgresql-Sun.log
-rw-------. 1 postgres postgres 205408 Jun 4 23:23 postgresql-Thu.log
-rw-------. 1 postgres postgres 326 Jun 9 05:10 postgresql-Tue.log
-rw-------. 1 postgres postgres 170420 Jun 10 14:14 postgresql-Wed.log
[root@sen2cap pg_log]# tail postgresql-Wed.log -f
< 2020-06-03 23:23:44.406 UTC >ERROR: invalid input syntax for type date: “V”
< 2020-06-03 23:23:44.406 UTC >STATEMENT: SELECT dh.id, dh.site_id, dh.satellite_id, dh.product_name, dh.full_path, dh.created_timestamp, dh.status_id, dh.no_of_retries, dh.product_date, dh.orbit_id, dh.status_reason, dh.tiles, dh.footprint, dh.orbit_type_id FROM public.downloader_history dh JOIN (SELECT d2.product_name, i.product_name AS intr, d2.site_id, d2.orbit_id, d2.satellite_id FROM public.downloader_history d2 JOIN public.downloader_history i ON i.site_id = d2.site_id AND i.orbit_id = d2.orbit_id AND i.satellite_id = d2.satellite_id WHERE ST_INTERSECTS(i.footprint, d2.footprint) AND DATE_PART(‘day’, d2.product_date - i.product_date) BETWEEN $1 AND $2 AND d2.satellite_id = 3) AS intersections ON intersections.site_id = dh.site_id AND intersections.orbit_id = dh.orbit_id AND intersections.satellite_id = dh.satellite_id AND intersections.product_name = dh.product_name LEFT JOIN (SELECT full_path, name, site_id, orbit_id, satellite_id, inserted_timestamp, GREATEST(substr(split_part(name, ‘’, 6), 2, 15)::date, substr(split_part(name, '’, 7), 1, 15)::date) as master_date FROM public.product) AS p ON p.site_id = dh.site_id AND p.orbit_id = dh.orbit_id AND p.satellite_id = dh.satellite_id AND CAST(dh.product_date as date) = p.master_date WHERE dh.satellite_id = 3 AND dh.site_id = $3 AND dh.status_id = 5 AND p.full_path IS NULL ORDER BY dh.product_date, dh.orbit_id, dh.product_name
< 2020-06-03 23:23:44.462 UTC >ERROR: invalid input syntax for type date: “V”
< 2020-06-03 23:23:44.462 UTC >STATEMENT: SELECT dh.id, dh.site_id, dh.satellite_id, dh.product_name, dh.full_path, dh.created_timestamp, dh.status_id, dh.no_of_retries, dh.product_date, dh.orbit_id, dh.status_reason, dh.tiles, dh.footprint, dh.orbit_type_id FROM public.downloader_history dh JOIN (SELECT d2.product_name, i.product_name AS intr, d2.site_id, d2.orbit_id, d2.satellite_id FROM public.downloader_history d2 JOIN public.downloader_history i ON i.site_id = d2.site_id AND i.orbit_id = d2.orbit_id AND i.satellite_id = d2.satellite_id WHERE ST_INTERSECTS(i.footprint, d2.footprint) AND DATE_PART(‘day’, d2.product_date - i.product_date) BETWEEN $1 AND $2 AND d2.satellite_id = 3) AS intersections ON intersections.site_id = dh.site_id AND intersections.orbit_id = dh.orbit_id AND intersections.satellite_id = dh.satellite_id AND intersections.product_name = dh.product_name LEFT JOIN (SELECT full_path, name, site_id, orbit_id, satellite_id, inserted_timestamp, GREATEST(substr(split_part(name, ‘’, 6), 2, 15)::date, substr(split_part(name, '’, 7), 1, 15)::date) as master_date FROM public.product) AS p ON p.site_id = dh.site_id AND p.orbit_id = dh.orbit_id AND p.satellite_id = dh.satellite_id AND CAST(dh.product_date as date) = p.master_date WHERE dh.satellite_id = 3 AND dh.site_id = $3 AND dh.status_id = 5 AND p.full_path IS NULL ORDER BY dh.product_date, dh.orbit_id, dh.product_name
< 2020-06-03 23:35:54.068 UTC >ERROR: invalid input syntax for type date: “V”
< 2020-06-03 23:35:54.068 UTC >STATEMENT: SELECT dh.id, dh.site_id, dh.satellite_id, dh.product_name, dh.full_path, dh.created_timestamp, dh.status_id, dh.no_of_retries, dh.product_date, dh.orbit_id, dh.status_reason, dh.tiles, dh.footprint, dh.orbit_type_id FROM public.downloader_history dh JOIN (SELECT d2.product_name, i.product_name AS intr, d2.site_id, d2.orbit_id, d2.satellite_id FROM public.downloader_history d2 JOIN public.downloader_history i ON i.site_id = d2.site_id AND i.orbit_id = d2.orbit_id AND i.satellite_id = d2.satellite_id WHERE ST_INTERSECTS(i.footprint, d2.footprint) AND DATE_PART(‘day’, d2.product_date - i.product_date) BETWEEN $1 AND $2 AND d2.satellite_id = 3) AS intersections ON intersections.site_id = dh.site_id AND intersections.orbit_id = dh.orbit_id AND intersections.satellite_id = dh.satellite_id AND intersections.product_name = dh.product_name LEFT JOIN (SELECT full_path, name, site_id, orbit_id, satellite_id, inserted_timestamp, GREATEST(substr(split_part(name, ‘’, 6), 2, 15)::date, substr(split_part(name, '’, 7), 1, 15)::date) as master_date FROM public.product) AS p ON p.site_id = dh.site_id AND p.orbit_id = dh.orbit_id AND p.satellite_id = dh.satellite_id AND CAST(dh.product_date as date) = p.master_date WHERE dh.satellite_id = 3 AND dh.site_id = $3 AND dh.status_id = 5 AND p.full_path IS NULL ORDER BY dh.product_date, dh.orbit_id, dh.product_name
< 2020-06-10 14:14:02.326 UTC >LOG: database system was shut down at 2020-06-09 05:10:14 UTC
< 2020-06-10 14:14:02.466 UTC >LOG: MultiXact member wraparound protections are now enabled
< 2020-06-10 14:14:02.468 UTC >LOG: database system is ready to accept connections
< 2020-06-10 14:14:02.468 UTC >LOG: autovacuum launcher started