pg_dump_one_by_one_terminal.log

bash ./pg_dump.sh
pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined access methods
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading default privileges
pg_dump: reading user-defined collations
pg_dump: reading user-defined conversions
pg_dump: reading type casts
pg_dump: reading transforms
pg_dump: reading table inheritance information
pg_dump: reading event triggers
pg_dump: finding extension tables
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table "public.spatial_ref_sys"
pg_dump: finding check constraints for table "public.spatial_ref_sys"
pg_dump: finding the columns and types of table "public.geography_columns"
pg_dump: finding the columns and types of table "public.geometry_columns"
pg_dump: finding the columns and types of table "tiger.geocode_settings"
pg_dump: finding the columns and types of table "tiger.geocode_settings_default"
pg_dump: finding the columns and types of table "tiger.direction_lookup"
pg_dump: finding the columns and types of table "tiger.secondary_unit_lookup"
pg_dump: finding the columns and types of table "tiger.state_lookup"
pg_dump: finding the columns and types of table "tiger.street_type_lookup"
pg_dump: finding default expressions of table "tiger.street_type_lookup"
pg_dump: finding the columns and types of table "tiger.place_lookup"
pg_dump: finding the columns and types of table "tiger.county_lookup"
pg_dump: finding the columns and types of table "tiger.countysub_lookup"
pg_dump: finding the columns and types of table "tiger.zip_lookup_all"
pg_dump: finding the columns and types of table "tiger.zip_lookup_base"
pg_dump: finding the columns and types of table "tiger.zip_lookup"
pg_dump: finding the columns and types of table "tiger.county"
pg_dump: finding default expressions of table "tiger.county"
pg_dump: finding check constraints for table "tiger.county"
pg_dump: finding the columns and types of table "tiger.state"
pg_dump: finding default expressions of table "tiger.state"
pg_dump: finding check constraints for table "tiger.state"
pg_dump: finding the columns and types of table "tiger.place"
pg_dump: finding default expressions of table "tiger.place"
pg_dump: finding check constraints for table "tiger.place"
pg_dump: finding the columns and types of table "tiger.zip_state"
pg_dump: finding the columns and types of table "tiger.zip_state_loc"
pg_dump: finding the columns and types of table "tiger.cousub"
pg_dump: finding default expressions of table "tiger.cousub"
pg_dump: finding check constraints for table "tiger.cousub"
pg_dump: finding the columns and types of table "tiger.edges"
pg_dump: finding default expressions of table "tiger.edges"
pg_dump: finding check constraints for table "tiger.edges"
pg_dump: finding the columns and types of table "tiger.addrfeat"
pg_dump: finding default expressions of table "tiger.addrfeat"
pg_dump: finding check constraints for table "tiger.addrfeat"
pg_dump: finding the columns and types of table "tiger.faces"
pg_dump: finding default expressions of table "tiger.faces"
pg_dump: finding check constraints for table "tiger.faces"
pg_dump: finding the columns and types of table "tiger.featnames"
pg_dump: finding default expressions of table "tiger.featnames"
pg_dump: finding the columns and types of table "tiger.addr"
pg_dump: finding default expressions of table "tiger.addr"
pg_dump: finding the columns and types of table "tiger.zcta5"
pg_dump: finding default expressions of table "tiger.zcta5"
pg_dump: finding check constraints for table "tiger.zcta5"
pg_dump: finding the columns and types of table "tiger.loader_platform"
pg_dump: finding the columns and types of table "tiger.loader_variables"
pg_dump: finding the columns and types of table "tiger.loader_lookuptables"
pg_dump: finding default expressions of table "tiger.loader_lookuptables"
pg_dump: finding the columns and types of table "tiger.tract"
pg_dump: finding default expressions of table "tiger.tract"
pg_dump: finding check constraints for table "tiger.tract"
pg_dump: finding check constraints for table "tiger.tract"
pg_dump: finding the columns and types of table "tiger.tabblock"
pg_dump: finding default expressions of table "tiger.tabblock"
pg_dump: finding check constraints for table "tiger.tabblock"
pg_dump: finding the columns and types of table "tiger.bg"
pg_dump: finding default expressions of table "tiger.bg"
pg_dump: finding check constraints for table "tiger.bg"
pg_dump: finding the columns and types of table "tiger.pagc_gaz"
pg_dump: finding default expressions of table "tiger.pagc_gaz"
pg_dump: finding the columns and types of table "tiger.pagc_lex"
pg_dump: finding default expressions of table "tiger.pagc_lex"
pg_dump: finding the columns and types of table "tiger.pagc_rules"
pg_dump: finding default expressions of table "tiger.pagc_rules"
pg_dump: finding the columns and types of table "topology.topology"
pg_dump: finding default expressions of table "topology.topology"
pg_dump: finding the columns and types of table "topology.layer"
pg_dump: finding default expressions of table "topology.layer"
pg_dump: finding the columns and types of table "public.pg_stat_statements"
pg_dump: finding the columns and types of table "public.raster_columns"
pg_dump: finding the columns and types of table "public.raster_overviews"
pg_dump: finding the columns and types of table "public.planet_osm_nodes"
pg_dump: finding the columns and types of table "public.planet_osm_ways"
pg_dump: finding the columns and types of table "public.planet_osm_rels"
pg_dump: finding the columns and types of table "public.planet_osm_polygon"
pg_dump: finding the columns and types of table "public.planet_osm_line"
pg_dump: finding the columns and types of table "public.planet_osm_point"
pg_dump: finding the columns and types of table "public.planet_osm_roads"
pg_dump: finding the columns and types of table "public.gadm36"
pg_dump: finding default expressions of table "public.gadm36"
pg_dump: finding the columns and types of table "public.country_codes"
pg_dump: finding the columns and types of table "public.agg_gadm36_areas"
pg_dump: finding the columns and types of table "public.agg_gadm36_geom_areas_admin_div5"
pg_dump: finding the columns and types of table "public.agg_gadm36_geom_areas_admin_div4"
pg_dump: finding the columns and types of table "public.agg_gadm36_geom_areas_admin_div3"
pg_dump: finding the columns and types of table "public.agg_gadm36_geom_areas_admin_div2"
pg_dump: finding the columns and types of table "public.agg_gadm36_geom_areas_admin_div1"
pg_dump: finding the columns and types of table "public.agg_gadm36_geom_areas_country"
pg_dump: finding the columns and types of table "public.raw_tiles_worldpop2020_100m"
pg_dump: finding default expressions of table "public.raw_tiles_worldpop2020_100m"
pg_dump: finding the columns and types of table "public.raster_polygons_worldpop2020_100m"
pg_dump: finding default expressions of table "public.raster_polygons_worldpop2020_100m"
pg_dump: finding the columns and types of table "public.cells_worldpop2020_100m"
pg_dump: finding default expressions of table "public.raw_tiles_worldpop2020_1km"
pg_dump: finding the columns and types of table "public.raster_polygons_worldpop2020_1km"
pg_dump: finding default expressions of table "public.raster_polygons_worldpop2020_1km"
pg_dump: finding the columns and types of table "public.cells_worldpop2020_1km"
pg_dump: finding the columns and types of table "{{all the tables in all the schemas}}"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading indexes for table "public.spatial_ref_sys"
pg_dump: reading indexes for table "tiger.geocode_settings"
pg_dump: reading indexes for table "tiger.geocode_settings_default"
pg_dump: reading indexes for table "tiger.direction_lookup"
pg_dump: reading indexes for table "tiger.secondary_unit_lookup"
pg_dump: reading indexes for table "tiger.state_lookup"
pg_dump: reading indexes for table "tiger.street_type_lookup"
pg_dump: reading indexes for table "tiger.place_lookup"
pg_dump: reading indexes for table "tiger.county_lookup"
pg_dump: reading indexes for table "tiger.countysub_lookup"
pg_dump: reading indexes for table "tiger.zip_lookup_base"
pg_dump: reading indexes for table "tiger.zip_lookup"
pg_dump: reading indexes for table "tiger.county"
pg_dump: reading indexes for table "tiger.state"
pg_dump: reading indexes for table "tiger.place"
pg_dump: reading indexes for table "tiger.zip_state"
pg_dump: reading indexes for table "tiger.zip_state_loc"
pg_dump: reading indexes for table "tiger.cousub"
pg_dump: reading indexes for table "tiger.edges"
pg_dump: reading indexes for table "tiger.addrfeat"
pg_dump: reading indexes for table "tiger.faces"
pg_dump: reading indexes for table "tiger.featnames"
pg_dump: reading indexes for table "tiger.addr"
pg_dump: reading indexes for table "tiger.zcta5"
pg_dump: reading indexes for table "tiger.loader_platform"
pg_dump: reading indexes for table "tiger.tract"
pg_dump: reading indexes for table "tiger.tabblock"
pg_dump: reading indexes for table "tiger.bg"
pg_dump: reading indexes for table "tiger.pagc_gaz"
pg_dump: reading indexes for table "tiger.pagc_lex"
pg_dump: reading indexes for table "tiger.pagc_rules"
pg_dump: reading indexes for table "topology.topology"
pg_dump: reading indexes for table "topology.layer"
pg_dump: reading indexes for table "{{all the tables in all the schemas}}"
pg_dump: flagging indexes in partitioned tables
pg_dump: reading extended statistics
pg_dump: reading constraints
pg_dump: reading foreign key constraints for table "osm_qa.osm_religion"
pg_dump: reading foreign key constraints for table "osm_qa.osm_denomination"
pg_dump: reading triggers
pg_dump: reading triggers for table "osm_qa.osm_religion"
pg_dump: reading triggers for table "osm_qa.osm_denomination"
pg_dump: reading rewrite rules
pg_dump: reading policies
pg_dump: reading row-level security policies
pg_dump: reading publications
pg_dump: reading publication membership
pg_dump: reading subscriptions
pg_dump: reading large objects
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: saving search_path =
pg_dump: saving database definition
pg_dump: dumping contents of table "{{all the tables in all the schemas}}"
pg_dump: dumping contents of table "public.spatial_ref_sys"
pg_dump: dumping contents of table "tiger.geocode_settings"
pg_dump: dumping contents of table "tiger.pagc_gaz"
pg_dump: dumping contents of table "tiger.pagc_lex"
pg_dump: dumping contents of table "tiger.pagc_rules"
pg_dump: dumping contents of table "topology.topology"
pg_dump: dumping contents of table "topology.layer"
pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
pg_dump: error: query failed: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
pg_dump: error: query was: SELECT n.tableoid, n.oid, n.nspname, (SELECT rolname FROM pg_catalog.pg_roles WHERE oid = nspowner) AS rolname, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(n.nspacl,pg_catalog.acldefault('n',n.nspowner))) WITH ORDINALITY AS perm(acl,row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault('n',n.nspowner))) AS init(init_acl) WHERE acl = init_acl)) as foo) as nspacl, (SELECT pg_catalog.array_agg(acl ORDER BY row_n) FROM (SELECT acl, row_n FROM pg_catalog.unnest(coalesce(pip.initprivs,pg_catalog.acldefault('n',n.nspowner))) WITH ORDINALITY AS initp(acl,row_n) WHERE NOT EXISTS ( SELECT 1 FROM pg_catalog.unnest(coalesce(n.nspacl,pg_catalog.acldefault('n',n.nspowner))) AS permp(orig_acl) WHERE acl = orig_acl)) as foo) as rnspacl, NULL as initnspacl, NULL as initrnspacl FROM pg_namespace n LEFT JOIN pg_init_privs pip ON (n.oid = pip.objoid AND pip.classoid = 'pg_namespace'::regclass AND pip.objsubid = 0)
pg_dump: error: connection to database "quito" failed: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  the database system is in recovery mode
pg_dump: error: connection to database "zagreb" failed: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  the database system is in recovery mode