pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedStrange "permission denied" errors on pg_restore
11+ messages / 5 participants
[nested] [flat]
* Strange "permission denied" errors on pg_restore
@ 2024-06-28 13:34 Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 04:31 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 11+ messages in thread
From: Ron Johnson @ 2024-06-28 13:34 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
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;
Attachments:
[text/plain] restore_errors.txt (25.5K, ../../CANzqJaBrzXfebHJaDLRWenr4WRgvRssTgEQR_O20N0sSv9MHLw@mail.gmail.com/3-restore_errors.txt)
download | inline:
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;
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Strange "permission denied" errors on pg_restore
2024-06-28 13:34 Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
@ 2024-06-29 04:31 ` Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:04 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: Laurenz Albe @ 2024-06-29 04:31 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Fri, 2024-06-28 at 09:34 -0400, Ron Johnson wrote:
> pg_restore: error: COPY failed for table "batch_rp4_y2022m08": ERROR: permission denied for schema tapschema
- Was the database you restored into totally empty?
- What was the exact "pg_restore" command line?
- What was the exact command line to take the dump?
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Strange "permission denied" errors on pg_restore
2024-06-28 13:34 Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 04:31 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
@ 2024-06-29 05:04 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 05:13 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 11+ messages in thread
From: Ron Johnson @ 2024-06-29 05:04 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Sat, Jun 29, 2024 at 12:31 AM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> On Fri, 2024-06-28 at 09:34 -0400, Ron Johnson wrote:
> > pg_restore: error: COPY failed for table "batch_rp4_y2022m08": ERROR:
> permission denied for schema tapschema
>
> - Was the database you restored into totally empty?
>
> - What was the exact "pg_restore" command line?
>
pg_restore -v --clean --create -Fd -j6 --dbname=postgres tap &>
tap_restore.log
> - What was the exact command line to take the dump?
>
declare -i Threads=$((`nproc`*3/4))
declare -i Zlvl=6
DB=tap
pg_dump -j ${Threads} -Z${ZLvl} -v -C -Fd --file=$DB $DB 2> ${DB}_pgdump.log
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Strange "permission denied" errors on pg_restore
2024-06-28 13:34 Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 04:31 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:04 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
@ 2024-06-29 05:13 ` Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:18 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: Laurenz Albe @ 2024-06-29 05:13 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Sat, 2024-06-29 at 01:04 -0400, Ron Johnson wrote:
> On Sat, Jun 29, 2024 at 12:31 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> > On Fri, 2024-06-28 at 09:34 -0400, Ron Johnson wrote:
> > > pg_restore: error: COPY failed for table "batch_rp4_y2022m08": ERROR: permission denied for schema tapschema
> >
> > - Was the database you restored into totally empty?
> >
> > - What was the exact "pg_restore" command line?
>
> pg_restore -v --clean --create -Fd -j6 --dbname=postgres tap &> tap_restore.log
So the database was clean (newly created).
You should perform the restore as a superuser or as a user that has all
the required permissions. Restoring with a non-superuser can be tricky.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Strange "permission denied" errors on pg_restore
2024-06-28 13:34 Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 04:31 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:04 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 05:13 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
@ 2024-06-29 05:18 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 14:54 ` Re: Strange "permission denied" errors on pg_restore Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 11+ messages in thread
From: Ron Johnson @ 2024-06-29 05:18 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Sat, Jun 29, 2024 at 1:13 AM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> On Sat, 2024-06-29 at 01:04 -0400, Ron Johnson wrote:
> > On Sat, Jun 29, 2024 at 12:31 AM Laurenz Albe <laurenz.albe@cybertec.at>
> wrote:
> > > On Fri, 2024-06-28 at 09:34 -0400, Ron Johnson wrote:
> > > > pg_restore: error: COPY failed for table "batch_rp4_y2022m08":
> ERROR: permission denied for schema tapschema
> > >
> > > - Was the database you restored into totally empty?
> > >
> > > - What was the exact "pg_restore" command line?
> >
> > pg_restore -v --clean --create -Fd -j6 --dbname=postgres tap &>
> tap_restore.log
>
> So the database was clean (newly created).
>
> You should perform the restore as a superuser or as a user that has all
> the required permissions. Restoring with a non-superuser can be tricky.
>
I do everything database-related as user "postgres". Only "sudo yum" is
run from my personal account.
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Strange "permission denied" errors on pg_restore
2024-06-28 13:34 Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 04:31 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:04 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 05:13 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:18 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
@ 2024-06-29 14:54 ` Tom Lane <tgl@sss.pgh.pa.us>
2024-06-29 22:12 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: Tom Lane @ 2024-06-29 14:54 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Ron Johnson <ronljohnsonjr@gmail.com> writes:
> On Sat, Jun 29, 2024 at 1:13 AM Laurenz Albe <laurenz.albe@cybertec.at>
> wrote:
>> You should perform the restore as a superuser or as a user that has all
>> the required permissions. Restoring with a non-superuser can be tricky.
> I do everything database-related as user "postgres". Only "sudo yum" is
> run from my personal account.
The failing query seems to be a foreign-key enforcement check that
happened to be triggered from COPY. Those are run as the owner of
the table that is being checked. So it appears that in
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
the owner of table "lockbox" lacks usage permission on the containing
schema "tapschema". That's a most bizarre situation and would have
caused the same sort of FK failures in the originating database as
well. pg_dump can't really promise to restore databases containing
arbitrarily-broken permissions settings.
regards, tom lane
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Strange "permission denied" errors on pg_restore
2024-06-28 13:34 Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 04:31 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:04 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 05:13 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:18 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 14:54 ` Re: Strange "permission denied" errors on pg_restore Tom Lane <tgl@sss.pgh.pa.us>
@ 2024-06-29 22:12 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 22:30 ` Re: Strange "permission denied" errors on pg_restore Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 11+ messages in thread
From: Ron Johnson @ 2024-06-29 22:12 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Sat, Jun 29, 2024 at 10:54 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Ron Johnson <ronljohnsonjr@gmail.com> writes:
> > On Sat, Jun 29, 2024 at 1:13 AM Laurenz Albe <laurenz.albe@cybertec.at>
> > wrote:
> >> You should perform the restore as a superuser or as a user that has all
> >> the required permissions. Restoring with a non-superuser can be tricky.
>
> > I do everything database-related as user "postgres". Only "sudo yum" is
> > run from my personal account.
>
> The failing query seems to be a foreign-key enforcement check that
> happened to be triggered from COPY. Those are run as the owner of
> the table that is being checked.
I thought FK constraints were applied *after* tables were copied.
> So it appears that in
>
> 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
>
> the owner of table "lockbox" lacks usage permission on the containing
> schema "tapschema".
Turns out that user "postgres" owns "tapschema".
> That's a most bizarre situation and would have
> caused the same sort of FK failures in the originating database as
> well.
Interesting. No one complained (but this is a pre-prod server, and people
are busy with other projects).
> pg_dump can't really promise to restore databases containing
> arbitrarily-broken permissions settings.
>
There are TWELVE THOUSAND foreign key constraints in 'tapschema', and
pg_restore only complained about 27 of them.
tap=# select contype, count(*)
from pg_constraint
where connamespace::regnamespace::text = 'tapschema'
group by contype;
contype | count
---------+-------
f | 11964
p | 450
(2 rows)
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Strange "permission denied" errors on pg_restore
2024-06-28 13:34 Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 04:31 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:04 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 05:13 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:18 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 14:54 ` Re: Strange "permission denied" errors on pg_restore Tom Lane <tgl@sss.pgh.pa.us>
2024-06-29 22:12 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
@ 2024-06-29 22:30 ` Scott Ribe <scott_ribe@elevated-dev.com>
2024-06-29 22:34 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: Scott Ribe @ 2024-06-29 22:30 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Could it be that someone accidentally changed ownership after data had been created?
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Strange "permission denied" errors on pg_restore
2024-06-28 13:34 Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 04:31 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:04 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 05:13 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:18 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 14:54 ` Re: Strange "permission denied" errors on pg_restore Tom Lane <tgl@sss.pgh.pa.us>
2024-06-29 22:12 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 22:30 ` Re: Strange "permission denied" errors on pg_restore Scott Ribe <scott_ribe@elevated-dev.com>
@ 2024-06-29 22:34 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-30 05:13 ` Re: Strange "permission denied" errors on pg_restore Wasim Devale <wasimd60@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: Ron Johnson @ 2024-06-29 22:34 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Sat, Jun 29, 2024 at 6:30 PM Scott Ribe <scott_ribe@elevated-dev.com>
wrote:
> Could it be that someone accidentally changed ownership after data had
> been created?
>
All tables (except one named "foo") are owned by the service account
fis_tap.
postgres=# select oid
postgres=# from pg_roles
postgres-# where rolname='fis_tap';
oid
-------
16386
(1 row)
tap=# select relowner, count(*)
from pg_class
where relkind in ('r', 't', 'p')
and relnamespace::regnamespace::text = 'tapschema'
group by relowner;
relowner | count
----------+-------
10 | 1
16386 | 30980
(2 rows)
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Strange "permission denied" errors on pg_restore
2024-06-28 13:34 Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 04:31 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:04 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 05:13 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:18 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 14:54 ` Re: Strange "permission denied" errors on pg_restore Tom Lane <tgl@sss.pgh.pa.us>
2024-06-29 22:12 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 22:30 ` Re: Strange "permission denied" errors on pg_restore Scott Ribe <scott_ribe@elevated-dev.com>
2024-06-29 22:34 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
@ 2024-06-30 05:13 ` Wasim Devale <wasimd60@gmail.com>
2024-06-30 06:48 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 11+ messages in thread
From: Wasim Devale @ 2024-06-30 05:13 UTC (permalink / raw)
To: ronljohnsonjr@gmail.com; +Cc: pgsql-admin@lists.postgresql.org
Can we change relowner to 10 ? After data is loaded in the database?
On Sun, 30 Jun, 2024, 4:05 am Ron Johnson, <ronljohnsonjr@gmail.com> wrote:
> On Sat, Jun 29, 2024 at 6:30 PM Scott Ribe <scott_ribe@elevated-dev.com>
> wrote:
>
>> Could it be that someone accidentally changed ownership after data had
>> been created?
>>
>
> All tables (except one named "foo") are owned by the service account
> fis_tap.
>
> postgres=# select oid
> postgres=# from pg_roles
> postgres-# where rolname='fis_tap';
> oid
> -------
> 16386
> (1 row)
>
> tap=# select relowner, count(*)
> from pg_class
> where relkind in ('r', 't', 'p')
> and relnamespace::regnamespace::text = 'tapschema'
> group by relowner;
> relowner | count
> ----------+-------
> 10 | 1
> 16386 | 30980
> (2 rows)
>
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Strange "permission denied" errors on pg_restore
2024-06-28 13:34 Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 04:31 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:04 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 05:13 ` Re: Strange "permission denied" errors on pg_restore Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:18 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 14:54 ` Re: Strange "permission denied" errors on pg_restore Tom Lane <tgl@sss.pgh.pa.us>
2024-06-29 22:12 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 22:30 ` Re: Strange "permission denied" errors on pg_restore Scott Ribe <scott_ribe@elevated-dev.com>
2024-06-29 22:34 ` Re: Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-30 05:13 ` Re: Strange "permission denied" errors on pg_restore Wasim Devale <wasimd60@gmail.com>
@ 2024-06-30 06:48 ` Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 11+ messages in thread
From: Ron Johnson @ 2024-06-30 06:48 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
We *can*, but the software vendor wants everything owned by the service
account.
On Sun, Jun 30, 2024 at 1:13 AM Wasim Devale <wasimd60@gmail.com> wrote:
> Can we change relowner to 10 ? After data is loaded in the database?
>
> On Sun, 30 Jun, 2024, 4:05 am Ron Johnson, <ronljohnsonjr@gmail.com>
> wrote:
>
>> On Sat, Jun 29, 2024 at 6:30 PM Scott Ribe <scott_ribe@elevated-dev.com>
>> wrote:
>>
>>> Could it be that someone accidentally changed ownership after data had
>>> been created?
>>>
>>
>> All tables (except one named "foo") are owned by the service account
>> fis_tap.
>>
>> postgres=# select oid
>> postgres=# from pg_roles
>> postgres-# where rolname='fis_tap';
>> oid
>> -------
>> 16386
>> (1 row)
>>
>> tap=# select relowner, count(*)
>> from pg_class
>> where relkind in ('r', 't', 'p')
>> and relnamespace::regnamespace::text = 'tapschema'
>> group by relowner;
>> relowner | count
>> ----------+-------
>> 10 | 1
>> 16386 | 30980
>> (2 rows)
>>
>>
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2024-06-30 06:48 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-06-28 13:34 Strange "permission denied" errors on pg_restore Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 04:31 ` Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:04 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 05:13 ` Laurenz Albe <laurenz.albe@cybertec.at>
2024-06-29 05:18 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 14:54 ` Tom Lane <tgl@sss.pgh.pa.us>
2024-06-29 22:12 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-29 22:30 ` Scott Ribe <scott_ribe@elevated-dev.com>
2024-06-29 22:34 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-06-30 05:13 ` Wasim Devale <wasimd60@gmail.com>
2024-06-30 06:48 ` Ron Johnson <ronljohnsonjr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox