PG 16.3, of a PG 16 pg_dump of a PG 15.7 database.
Here's a sample of the errors from the "pg_restore -v" log, while attached are samples from the postgresql.log file:
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 847489; 0 1814433 TABLE DATA batch_rp4_y2022m08 fis_tap
pg_restore: error: COPY failed for table "batch_rp4_y2022m08": ERROR: permission denied for schema tapschema
LINE 1: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id...
^
QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 847492; 0 1814598 TABLE DATA batch_rp4_y2022m05 fis_tap
pg_restore: error: COPY failed for table "batch_rp4_y2022m05": ERROR: permission denied for schema tapschema
LINE 1: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id...
^
QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 847491; 0 1814543 TABLE DATA batch_rp4_y2022m06 fis_tap
pg_restore: error: COPY failed for table "batch_rp4_y2022m06": ERROR: permission denied for schema tapschema
LINE 1: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id...
^
QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
pg_restore: finished item 847489 TABLE DATA batch_rp4_y2022m08
pg_restore: from TOC entry 847489; 0 1814433 TABLE DATA batch_rp4_y2022m08 fis_tap
pg_restore: error: COPY failed for table "batch_rp4_y2022m08": ERROR: permission denied for schema tapschema
LINE 1: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id...
^
QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 847492; 0 1814598 TABLE DATA batch_rp4_y2022m05 fis_tap
pg_restore: error: COPY failed for table "batch_rp4_y2022m05": ERROR: permission denied for schema tapschema
LINE 1: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id...
^
QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 847491; 0 1814543 TABLE DATA batch_rp4_y2022m06 fis_tap
pg_restore: error: COPY failed for table "batch_rp4_y2022m06": ERROR: permission denied for schema tapschema
LINE 1: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id...
^
QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x
pg_restore: finished item 847489 TABLE DATA batch_rp4_y2022m08
The only errors were on COPY statements. The tables and indices were all created, and attached to their parent tables.
Individually restoring the tables from the backup succeeded without error.
There's a FK relationship from batch.lockbox_id to lockbox.lockbox_id, but why should that matter, since FK constraints are created after tables are loaded?
But that gets me thinking... table "batch" is doubly-partitioned: first on the "rp" number, and then the batch_rpX tables are partitioned by the process_date. Might the FK on the batch_rp4 table have already been created?
2024-06-27 04:01:38.462 EDT [local] postgres tap 480718 COPY pg_restore 42501 ERROR: 42501: permission denied for schema tapschema at character 20 2024-06-27 04:01:38.462 EDT [local] postgres tap 480718 COPY pg_restore 42501 QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x 2024-06-27 04:01:38.462 EDT [local] postgres tap 480718 COPY pg_restore 42501 LOCATION: aclcheck_error, aclchk.c:2809 2024-06-27 04:01:38.462 EDT [local] postgres tap 480718 COPY pg_restore 42501 STATEMENT: COPY tapschema.batch_rp4_y2022m08 (batch_id, number, batch_file_type_code_id, import_status_code_id, batch_identifier, paired_batch_id, file_sequence_number, start_time, export_time, balanced, deposit_time, check_count, check_total, doc_count, credit_date, invoice_total, invoice_count, batch_limit, association_type, truncation_flag, eod_status, ocr_count, unprocessable_items, no_check_items, non_systemic_character_count, systemic_character_count, repair_count, doctus_page_count, front_image_count, rear_image_count, front_ocr_count, rear_ocr_count, batch_status, doctus_character_count, stop_check_count, bank_name, affiliate, pass1_mach_no, zip_filename, image_path, lockbox_id, site_code_id, batch_mode_code_id, processing_bank_id, weekend_reporting_date, cds_deposit_time, cds_file_create_time, cds_archive_time, check_21_count, check_21_total, arc_count, arc_total, arc_suspect_count, arc_suspect_total, pending_count, pending_total, duplicate_count, duplicate_total, item_state, arc_status, cds_batch_number, cds_full_batch_number, rebatching_source, rebatching_rule, coupon_count, correspondence_count, envelope_count, cds_system_time, cds_cut_off_date, work_flow, inbound_batch_number, inbound_file_name, inbound_receipt_time, third_party_provider, mail_out_state, exported_on, aux_on_us, tms_check_count, tms_check_total, tms_invoice_total, tms_invoice_count, retention_date, archive_front_check_image_count, archive_rear_check_image_count, archive_front_invoice_image_count, archive_rear_invoice_image_count, archive_front_coupon_image_count, archive_rear_coupon_image_count, archive_front_correspondence_image_count, archive_rear_correspondence_image_count, archive_front_envelope_image_count, archive_rear_envelope_image_count, backload_manifest_id, cds_weekend_reporting_date, batch_output_type, bank_retention_on, customer_retention_on, lockbox_retention_on, arc_weekend_reporting_date, virutal_endorsement_date, capture_source, consolidation_number, doc_group, deposit_tran_code, deposit_rt_number, retry_count, doc_archive_img_count_exclude_no_image, processing_date_number, ocr_item_state, ocr_started_on, ocr_finished_on, ems_cutoff_time, watchlist_item_state, rdc_number, rdc_created_on, rdc_created_by, holdover_period, holdover_count, created_on, created_by, modified_on, modified_by, process_date, partition_type) FROM stdin; 2024-06-27 04:01:38.465 EDT [local] postgres tap 480710 COPY pg_restore 42501 ERROR: 42501: permission denied for schema tapschema at character 20 2024-06-27 04:01:38.465 EDT [local] postgres tap 480710 COPY pg_restore 42501 QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x 2024-06-27 04:01:38.465 EDT [local] postgres tap 480710 COPY pg_restore 42501 LOCATION: aclcheck_error, aclchk.c:2809 2024-06-27 04:01:38.465 EDT [local] postgres tap 480710 COPY pg_restore 42501 STATEMENT: COPY tapschema.batch_rp4_y2022m05 (batch_id, number, batch_file_type_code_id, import_status_code_id, batch_identifier, paired_batch_id, file_sequence_number, start_time, export_time, balanced, deposit_time, check_count, check_total, doc_count, credit_date, invoice_total, invoice_count, batch_limit, association_type, truncation_flag, eod_status, ocr_count, unprocessable_items, no_check_items, non_systemic_character_count, systemic_character_count, repair_count, doctus_page_count, front_image_count, rear_image_count, front_ocr_count, rear_ocr_count, batch_status, doctus_character_count, stop_check_count, bank_name, affiliate, pass1_mach_no, zip_filename, image_path, lockbox_id, site_code_id, batch_mode_code_id, processing_bank_id, weekend_reporting_date, cds_deposit_time, cds_file_create_time, cds_archive_time, check_21_count, check_21_total, arc_count, arc_total, arc_suspect_count, arc_suspect_total, pending_count, pending_total, duplicate_count, duplicate_total, item_state, arc_status, cds_batch_number, cds_full_batch_number, rebatching_source, rebatching_rule, coupon_count, correspondence_count, envelope_count, cds_system_time, cds_cut_off_date, work_flow, inbound_batch_number, inbound_file_name, inbound_receipt_time, third_party_provider, mail_out_state, exported_on, aux_on_us, tms_check_count, tms_check_total, tms_invoice_total, tms_invoice_count, retention_date, archive_front_check_image_count, archive_rear_check_image_count, archive_front_invoice_image_count, archive_rear_invoice_image_count, archive_front_coupon_image_count, archive_rear_coupon_image_count, archive_front_correspondence_image_count, archive_rear_correspondence_image_count, archive_front_envelope_image_count, archive_rear_envelope_image_count, backload_manifest_id, cds_weekend_reporting_date, batch_output_type, bank_retention_on, customer_retention_on, lockbox_retention_on, arc_weekend_reporting_date, virutal_endorsement_date, capture_source, consolidation_number, doc_group, deposit_tran_code, deposit_rt_number, retry_count, doc_archive_img_count_exclude_no_image, processing_date_number, ocr_item_state, ocr_started_on, ocr_finished_on, ems_cutoff_time, watchlist_item_state, rdc_number, rdc_created_on, rdc_created_by, holdover_period, holdover_count, created_on, created_by, modified_on, modified_by, process_date, partition_type) FROM stdin; 2024-06-27 04:01:38.468 EDT [local] postgres tap 480720 COPY pg_restore 42501 ERROR: 42501: permission denied for schema tapschema at character 20 2024-06-27 04:01:38.468 EDT [local] postgres tap 480720 COPY pg_restore 42501 QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x 2024-06-27 04:01:38.468 EDT [local] postgres tap 480720 COPY pg_restore 42501 LOCATION: aclcheck_error, aclchk.c:2809 2024-06-27 04:01:38.468 EDT [local] postgres tap 480720 COPY pg_restore 42501 STATEMENT: COPY tapschema.batch_rp4_y2022m06 (batch_id, number, batch_file_type_code_id, import_status_code_id, batch_identifier, paired_batch_id, file_sequence_number, start_time, export_time, balanced, deposit_time, check_count, check_total, doc_count, credit_date, invoice_total, invoice_count, batch_limit, association_type, truncation_flag, eod_status, ocr_count, unprocessable_items, no_check_items, non_systemic_character_count, systemic_character_count, repair_count, doctus_page_count, front_image_count, rear_image_count, front_ocr_count, rear_ocr_count, batch_status, doctus_character_count, stop_check_count, bank_name, affiliate, pass1_mach_no, zip_filename, image_path, lockbox_id, site_code_id, batch_mode_code_id, processing_bank_id, weekend_reporting_date, cds_deposit_time, cds_file_create_time, cds_archive_time, check_21_count, check_21_total, arc_count, arc_total, arc_suspect_count, arc_suspect_total, pending_count, pending_total, duplicate_count, duplicate_total, item_state, arc_status, cds_batch_number, cds_full_batch_number, rebatching_source, rebatching_rule, coupon_count, correspondence_count, envelope_count, cds_system_time, cds_cut_off_date, work_flow, inbound_batch_number, inbound_file_name, inbound_receipt_time, third_party_provider, mail_out_state, exported_on, aux_on_us, tms_check_count, tms_check_total, tms_invoice_total, tms_invoice_count, retention_date, archive_front_check_image_count, archive_rear_check_image_count, archive_front_invoice_image_count, archive_rear_invoice_image_count, archive_front_coupon_image_count, archive_rear_coupon_image_count, archive_front_correspondence_image_count, archive_rear_correspondence_image_count, archive_front_envelope_image_count, archive_rear_envelope_image_count, backload_manifest_id, cds_weekend_reporting_date, batch_output_type, bank_retention_on, customer_retention_on, lockbox_retention_on, arc_weekend_reporting_date, virutal_endorsement_date, capture_source, consolidation_number, doc_group, deposit_tran_code, deposit_rt_number, retry_count, doc_archive_img_count_exclude_no_image, processing_date_number, ocr_item_state, ocr_started_on, ocr_finished_on, ems_cutoff_time, watchlist_item_state, rdc_number, rdc_created_on, rdc_created_by, holdover_period, holdover_count, created_on, created_by, modified_on, modified_by, process_date, partition_type) FROM stdin; 2024-06-27 04:01:38.605 EDT [local] postgres tap 480716 COPY pg_restore 42501 ERROR: 42501: permission denied for schema tapschema at character 20 2024-06-27 04:01:38.605 EDT [local] postgres tap 480716 COPY pg_restore 42501 QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x 2024-06-27 04:01:38.605 EDT [local] postgres tap 480716 COPY pg_restore 42501 LOCATION: aclcheck_error, aclchk.c:2809 2024-06-27 04:01:38.605 EDT [local] postgres tap 480716 COPY pg_restore 42501 STATEMENT: COPY tapschema.batch_rp4_y2022m12 (batch_id, number, batch_file_type_code_id, import_status_code_id, batch_identifier, paired_batch_id, file_sequence_number, start_time, export_time, balanced, deposit_time, check_count, check_total, doc_count, credit_date, invoice_total, invoice_count, batch_limit, association_type, truncation_flag, eod_status, ocr_count, unprocessable_items, no_check_items, non_systemic_character_count, systemic_character_count, repair_count, doctus_page_count, front_image_count, rear_image_count, front_ocr_count, rear_ocr_count, batch_status, doctus_character_count, stop_check_count, bank_name, affiliate, pass1_mach_no, zip_filename, image_path, lockbox_id, site_code_id, batch_mode_code_id, processing_bank_id, weekend_reporting_date, cds_deposit_time, cds_file_create_time, cds_archive_time, check_21_count, check_21_total, arc_count, arc_total, arc_suspect_count, arc_suspect_total, pending_count, pending_total, duplicate_count, duplicate_total, item_state, arc_status, cds_batch_number, cds_full_batch_number, rebatching_source, rebatching_rule, coupon_count, correspondence_count, envelope_count, cds_system_time, cds_cut_off_date, work_flow, inbound_batch_number, inbound_file_name, inbound_receipt_time, third_party_provider, mail_out_state, exported_on, aux_on_us, tms_check_count, tms_check_total, tms_invoice_total, tms_invoice_count, retention_date, archive_front_check_image_count, archive_rear_check_image_count, archive_front_invoice_image_count, archive_rear_invoice_image_count, archive_front_coupon_image_count, archive_rear_coupon_image_count, archive_front_correspondence_image_count, archive_rear_correspondence_image_count, archive_front_envelope_image_count, archive_rear_envelope_image_count, backload_manifest_id, cds_weekend_reporting_date, batch_output_type, bank_retention_on, customer_retention_on, lockbox_retention_on, arc_weekend_reporting_date, virutal_endorsement_date, capture_source, consolidation_number, doc_group, deposit_tran_code, deposit_rt_number, retry_count, doc_archive_img_count_exclude_no_image, processing_date_number, ocr_item_state, ocr_started_on, ocr_finished_on, ems_cutoff_time, watchlist_item_state, rdc_number, rdc_created_on, rdc_created_by, holdover_period, holdover_count, created_on, created_by, modified_on, modified_by, process_date, partition_type) FROM stdin; 2024-06-27 04:01:38.669 EDT [local] postgres tap 480720 COPY pg_restore 42501 ERROR: 42501: permission denied for schema tapschema at character 20 2024-06-27 04:01:38.669 EDT [local] postgres tap 480720 COPY pg_restore 42501 QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x 2024-06-27 04:01:38.669 EDT [local] postgres tap 480720 COPY pg_restore 42501 LOCATION: aclcheck_error, aclchk.c:2809 2024-06-27 04:01:38.669 EDT [local] postgres tap 480720 COPY pg_restore 42501 STATEMENT: COPY tapschema.batch_rp4_y2022m11 (batch_id, number, batch_file_type_code_id, import_status_code_id, batch_identifier, paired_batch_id, file_sequence_number, start_time, export_time, balanced, deposit_time, check_count, check_total, doc_count, credit_date, invoice_total, invoice_count, batch_limit, association_type, truncation_flag, eod_status, ocr_count, unprocessable_items, no_check_items, non_systemic_character_count, systemic_character_count, repair_count, doctus_page_count, front_image_count, rear_image_count, front_ocr_count, rear_ocr_count, batch_status, doctus_character_count, stop_check_count, bank_name, affiliate, pass1_mach_no, zip_filename, image_path, lockbox_id, site_code_id, batch_mode_code_id, processing_bank_id, weekend_reporting_date, cds_deposit_time, cds_file_create_time, cds_archive_time, check_21_count, check_21_total, arc_count, arc_total, arc_suspect_count, arc_suspect_total, pending_count, pending_total, duplicate_count, duplicate_total, item_state, arc_status, cds_batch_number, cds_full_batch_number, rebatching_source, rebatching_rule, coupon_count, correspondence_count, envelope_count, cds_system_time, cds_cut_off_date, work_flow, inbound_batch_number, inbound_file_name, inbound_receipt_time, third_party_provider, mail_out_state, exported_on, aux_on_us, tms_check_count, tms_check_total, tms_invoice_total, tms_invoice_count, retention_date, archive_front_check_image_count, archive_rear_check_image_count, archive_front_invoice_image_count, archive_rear_invoice_image_count, archive_front_coupon_image_count, archive_rear_coupon_image_count, archive_front_correspondence_image_count, archive_rear_correspondence_image_count, archive_front_envelope_image_count, archive_rear_envelope_image_count, backload_manifest_id, cds_weekend_reporting_date, batch_output_type, bank_retention_on, customer_retention_on, lockbox_retention_on, arc_weekend_reporting_date, virutal_endorsement_date, capture_source, consolidation_number, doc_group, deposit_tran_code, deposit_rt_number, retry_count, doc_archive_img_count_exclude_no_image, processing_date_number, ocr_item_state, ocr_started_on, ocr_finished_on, ems_cutoff_time, watchlist_item_state, rdc_number, rdc_created_on, rdc_created_by, holdover_period, holdover_count, created_on, created_by, modified_on, modified_by, process_date, partition_type) FROM stdin; 2024-06-27 04:01:38.677 EDT [local] postgres tap 480710 COPY pg_restore 42501 ERROR: 42501: permission denied for schema tapschema at character 20 2024-06-27 04:01:38.677 EDT [local] postgres tap 480710 COPY pg_restore 42501 QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x 2024-06-27 04:01:38.677 EDT [local] postgres tap 480710 COPY pg_restore 42501 LOCATION: aclcheck_error, aclchk.c:2809 2024-06-27 04:01:38.677 EDT [local] postgres tap 480710 COPY pg_restore 42501 STATEMENT: COPY tapschema.batch_rp4_y2022m09 (batch_id, number, batch_file_type_code_id, import_status_code_id, batch_identifier, paired_batch_id, file_sequence_number, start_time, export_time, balanced, deposit_time, check_count, check_total, doc_count, credit_date, invoice_total, invoice_count, batch_limit, association_type, truncation_flag, eod_status, ocr_count, unprocessable_items, no_check_items, non_systemic_character_count, systemic_character_count, repair_count, doctus_page_count, front_image_count, rear_image_count, front_ocr_count, rear_ocr_count, batch_status, doctus_character_count, stop_check_count, bank_name, affiliate, pass1_mach_no, zip_filename, image_path, lockbox_id, site_code_id, batch_mode_code_id, processing_bank_id, weekend_reporting_date, cds_deposit_time, cds_file_create_time, cds_archive_time, check_21_count, check_21_total, arc_count, arc_total, arc_suspect_count, arc_suspect_total, pending_count, pending_total, duplicate_count, duplicate_total, item_state, arc_status, cds_batch_number, cds_full_batch_number, rebatching_source, rebatching_rule, coupon_count, correspondence_count, envelope_count, cds_system_time, cds_cut_off_date, work_flow, inbound_batch_number, inbound_file_name, inbound_receipt_time, third_party_provider, mail_out_state, exported_on, aux_on_us, tms_check_count, tms_check_total, tms_invoice_total, tms_invoice_count, retention_date, archive_front_check_image_count, archive_rear_check_image_count, archive_front_invoice_image_count, archive_rear_invoice_image_count, archive_front_coupon_image_count, archive_rear_coupon_image_count, archive_front_correspondence_image_count, archive_rear_correspondence_image_count, archive_front_envelope_image_count, archive_rear_envelope_image_count, backload_manifest_id, cds_weekend_reporting_date, batch_output_type, bank_retention_on, customer_retention_on, lockbox_retention_on, arc_weekend_reporting_date, virutal_endorsement_date, capture_source, consolidation_number, doc_group, deposit_tran_code, deposit_rt_number, retry_count, doc_archive_img_count_exclude_no_image, processing_date_number, ocr_item_state, ocr_started_on, ocr_finished_on, ems_cutoff_time, watchlist_item_state, rdc_number, rdc_created_on, rdc_created_by, holdover_period, holdover_count, created_on, created_by, modified_on, modified_by, process_date, partition_type) FROM stdin; 2024-06-27 04:01:38.739 EDT [local] postgres tap 480712 COPY pg_restore 42501 ERROR: 42501: permission denied for schema tapschema at character 20 2024-06-27 04:01:38.739 EDT [local] postgres tap 480712 COPY pg_restore 42501 QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x 2024-06-27 04:01:38.739 EDT [local] postgres tap 480712 COPY pg_restore 42501 LOCATION: aclcheck_error, aclchk.c:2809 2024-06-27 04:01:38.739 EDT [local] postgres tap 480712 COPY pg_restore 42501 STATEMENT: COPY tapschema.batch_rp4_y2022m04 (batch_id, number, batch_file_type_code_id, import_status_code_id, batch_identifier, paired_batch_id, file_sequence_number, start_time, export_time, balanced, deposit_time, check_count, check_total, doc_count, credit_date, invoice_total, invoice_count, batch_limit, association_type, truncation_flag, eod_status, ocr_count, unprocessable_items, no_check_items, non_systemic_character_count, systemic_character_count, repair_count, doctus_page_count, front_image_count, rear_image_count, front_ocr_count, rear_ocr_count, batch_status, doctus_character_count, stop_check_count, bank_name, affiliate, pass1_mach_no, zip_filename, image_path, lockbox_id, site_code_id, batch_mode_code_id, processing_bank_id, weekend_reporting_date, cds_deposit_time, cds_file_create_time, cds_archive_time, check_21_count, check_21_total, arc_count, arc_total, arc_suspect_count, arc_suspect_total, pending_count, pending_total, duplicate_count, duplicate_total, item_state, arc_status, cds_batch_number, cds_full_batch_number, rebatching_source, rebatching_rule, coupon_count, correspondence_count, envelope_count, cds_system_time, cds_cut_off_date, work_flow, inbound_batch_number, inbound_file_name, inbound_receipt_time, third_party_provider, mail_out_state, exported_on, aux_on_us, tms_check_count, tms_check_total, tms_invoice_total, tms_invoice_count, retention_date, archive_front_check_image_count, archive_rear_check_image_count, archive_front_invoice_image_count, archive_rear_invoice_image_count, archive_front_coupon_image_count, archive_rear_coupon_image_count, archive_front_correspondence_image_count, archive_rear_correspondence_image_count, archive_front_envelope_image_count, archive_rear_envelope_image_count, backload_manifest_id, cds_weekend_reporting_date, batch_output_type, bank_retention_on, customer_retention_on, lockbox_retention_on, arc_weekend_reporting_date, virutal_endorsement_date, capture_source, consolidation_number, doc_group, deposit_tran_code, deposit_rt_number, retry_count, doc_archive_img_count_exclude_no_image, processing_date_number, ocr_item_state, ocr_started_on, ocr_finished_on, ems_cutoff_time, watchlist_item_state, rdc_number, rdc_created_on, rdc_created_by, holdover_period, holdover_count, created_on, created_by, modified_on, modified_by, process_date, partition_type) FROM stdin; 2024-06-27 04:01:38.804 EDT [local] postgres tap 480716 COPY pg_restore 42501 ERROR: 42501: permission denied for schema tapschema at character 20 2024-06-27 04:01:38.804 EDT [local] postgres tap 480716 COPY pg_restore 42501 QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x 2024-06-27 04:01:38.804 EDT [local] postgres tap 480716 COPY pg_restore 42501 LOCATION: aclcheck_error, aclchk.c:2809 2024-06-27 04:01:38.804 EDT [local] postgres tap 480716 COPY pg_restore 42501 STATEMENT: COPY tapschema.batch_rp4_y2022m07 (batch_id, number, batch_file_type_code_id, import_status_code_id, batch_identifier, paired_batch_id, file_sequence_number, start_time, export_time, balanced, deposit_time, check_count, check_total, doc_count, credit_date, invoice_total, invoice_count, batch_limit, association_type, truncation_flag, eod_status, ocr_count, unprocessable_items, no_check_items, non_systemic_character_count, systemic_character_count, repair_count, doctus_page_count, front_image_count, rear_image_count, front_ocr_count, rear_ocr_count, batch_status, doctus_character_count, stop_check_count, bank_name, affiliate, pass1_mach_no, zip_filename, image_path, lockbox_id, site_code_id, batch_mode_code_id, processing_bank_id, weekend_reporting_date, cds_deposit_time, cds_file_create_time, cds_archive_time, check_21_count, check_21_total, arc_count, arc_total, arc_suspect_count, arc_suspect_total, pending_count, pending_total, duplicate_count, duplicate_total, item_state, arc_status, cds_batch_number, cds_full_batch_number, rebatching_source, rebatching_rule, coupon_count, correspondence_count, envelope_count, cds_system_time, cds_cut_off_date, work_flow, inbound_batch_number, inbound_file_name, inbound_receipt_time, third_party_provider, mail_out_state, exported_on, aux_on_us, tms_check_count, tms_check_total, tms_invoice_total, tms_invoice_count, retention_date, archive_front_check_image_count, archive_rear_check_image_count, archive_front_invoice_image_count, archive_rear_invoice_image_count, archive_front_coupon_image_count, archive_rear_coupon_image_count, archive_front_correspondence_image_count, archive_rear_correspondence_image_count, archive_front_envelope_image_count, archive_rear_envelope_image_count, backload_manifest_id, cds_weekend_reporting_date, batch_output_type, bank_retention_on, customer_retention_on, lockbox_retention_on, arc_weekend_reporting_date, virutal_endorsement_date, capture_source, consolidation_number, doc_group, deposit_tran_code, deposit_rt_number, retry_count, doc_archive_img_count_exclude_no_image, processing_date_number, ocr_item_state, ocr_started_on, ocr_finished_on, ems_cutoff_time, watchlist_item_state, rdc_number, rdc_created_on, rdc_created_by, holdover_period, holdover_count, created_on, created_by, modified_on, modified_by, process_date, partition_type) FROM stdin; 2024-06-27 04:01:38.825 EDT [local] postgres tap 480718 COPY pg_restore 42501 ERROR: 42501: permission denied for schema tapschema at character 20 2024-06-27 04:01:38.825 EDT [local] postgres tap 480718 COPY pg_restore 42501 QUERY: SELECT 1 FROM ONLY "tapschema"."lockbox" x WHERE "lockbox_id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x 2024-06-27 04:01:38.825 EDT [local] postgres tap 480718 COPY pg_restore 42501 LOCATION: aclcheck_error, aclchk.c:2809 2024-06-27 04:01:38.825 EDT [local] postgres tap 480718 COPY pg_restore 42501 STATEMENT: COPY tapschema.batch_rp4_y2022m10 (batch_id, number, batch_file_type_code_id, import_status_code_id, batch_identifier, paired_batch_id, file_sequence_number, start_time, export_time, balanced, deposit_time, check_count, check_total, doc_count, credit_date, invoice_total, invoice_count, batch_limit, association_type, truncation_flag, eod_status, ocr_count, unprocessable_items, no_check_items, non_systemic_character_count, systemic_character_count, repair_count, doctus_page_count, front_image_count, rear_image_count, front_ocr_count, rear_ocr_count, batch_status, doctus_character_count, stop_check_count, bank_name, affiliate, pass1_mach_no, zip_filename, image_path, lockbox_id, site_code_id, batch_mode_code_id, processing_bank_id, weekend_reporting_date, cds_deposit_time, cds_file_create_time, cds_archive_time, check_21_count, check_21_total, arc_count, arc_total, arc_suspect_count, arc_suspect_total, pending_count, pending_total, duplicate_count, duplicate_total, item_state, arc_status, cds_batch_number, cds_full_batch_number, rebatching_source, rebatching_rule, coupon_count, correspondence_count, envelope_count, cds_system_time, cds_cut_off_date, work_flow, inbound_batch_number, inbound_file_name, inbound_receipt_time, third_party_provider, mail_out_state, exported_on, aux_on_us, tms_check_count, tms_check_total, tms_invoice_total, tms_invoice_count, retention_date, archive_front_check_image_count, archive_rear_check_image_count, archive_front_invoice_image_count, archive_rear_invoice_image_count, archive_front_coupon_image_count, archive_rear_coupon_image_count, archive_front_correspondence_image_count, archive_rear_correspondence_image_count, archive_front_envelope_image_count, archive_rear_envelope_image_count, backload_manifest_id, cds_weekend_reporting_date, batch_output_type, bank_retention_on, customer_retention_on, lockbox_retention_on, arc_weekend_reporting_date, virutal_endorsement_date, capture_source, consolidation_number, doc_group, deposit_tran_code, deposit_rt_number, retry_count, doc_archive_img_count_exclude_no_image, processing_date_number, ocr_item_state, ocr_started_on, ocr_finished_on, ems_cutoff_time, watchlist_item_state, rdc_number, rdc_created_on, rdc_created_by, holdover_period, holdover_count, created_on, created_by, modified_on, modified_by, process_date, partition_type) FROM stdin;
