79347559

Date: 2025-01-11 05:31:04
Score: 0.5
Natty:
Report link

@ i tried using below command taking your suggestion, still giving same output and not restoring anything in table:

pg_restore -x --no-privileges --no-owner -h ... -p **** -U enterprisedb -d --data-only -v -n facility --table "facilitytype_linkedfacilitytype_map_dummy" -Fc "/home/clouduser/dbbackup/facilitytype_linkedfacilitytype_map_table_11_01_2025_1006.backup" > "/home/clouduser/dbbackup/facilitytype_linkedfacilitytype_map_table_11_01_2025_1006.txt" 2>&1

OUTPUT: nohup: ignoring input pg_restore: allocating AH for /home/clouduser/dbbackup/facilitytype_linkedfacilitytype_map_table_11_01_2025_1006.backup, format 1 pg_restore: read TOC entry 0 (ID 6072) for ENCODING ENCODING pg_restore: read TOC entry 1 (ID 6073) for STDSTRINGS STDSTRINGS pg_restore: read TOC entry 2 (ID 6074) for SEARCHPATH SEARCHPATH pg_restore: read TOC entry 3 (ID 6075) for DATABASE unicef_dev pg_restore: read TOC entry 4 (ID 341) for TABLE facilitytype_linkedfacilitytype_map pg_restore: read TOC entry 5 (ID 6076) for ACL TABLE facilitytype_linkedfacilitytype_map pg_restore: read TOC entry 6 (ID 6069) for TABLE DATA facilitytype_linkedfacilitytype_map pg_restore: read TOC entry 7 (ID 5901) for CONSTRAINT facilitytype_linkedfacilitytype_map facilitytype_linkedfacilitytype_map_pkey pg_restore: read TOC entry 8 (ID 5902) for FK CONSTRAINT facilitytype_linkedfacilitytype_map facilitytype_linkedfacilitytype_map_child_facility_type_id_fkey pg_restore: read TOC entry 9 (ID 5903) for FK CONSTRAINT facilitytype_linkedfacilitytype_map facilitytype_linkedfacilitytype_map_facility_type_id_fkey pg_restore: connecting to database for restore pg_restore: implied data-only restore

Reasons:
  • Long answer (-1):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Sahil Shaikh