============================================================================= Log started at Thu Mar 28 00:05:01 UTC 2024 lock taken at /tmp/update_udd.udd-mirror.lock Downloading udd.dump The database is already up-to-date, doing nothing. Releasing lock. removed '/tmp/update_udd.udd-mirror.lock' ============================================================================= Log started at Thu Mar 28 02:05:01 UTC 2024 lock taken at /tmp/update_udd.udd-mirror.lock Downloading udd.dump 2024-03-28 02:07:24 URL:https://udd.debian.org/dumps/udd.dump [2416531350/2416531350] -> "udd.dump" [1] ALTER DEFAULT PRIVILEGES FOR USER "udd" IN SCHEMA "public" GRANT SELECT ON TABLES TO "udd"; ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES FOR USER "udd-mirror" IN SCHEMA "public" GRANT SELECT ON TABLES TO "udd-mirror"; ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES FOR USER "public-udd-mirror" IN SCHEMA "public" GRANT SELECT ON TABLES TO "public-udd-mirror"; ALTER DEFAULT PRIVILEGES CREATE EXTENSION debversion CREATE EXTENSION pg_restore: connecting to database for restore pg_restore: creating SCHEMA "history" pg_restore: creating EXTENSION "debversion" pg_restore: creating COMMENT "EXTENSION debversion" pg_restore: creating TYPE "public.bugs_severity" pg_restore: creating TYPE "public.dehs_status" pg_restore: creating TYPE "public.ftp_autoreject_level" pg_restore: creating TYPE "public.ftp_autoreject_type" pg_restore: creating TYPE "public.lintian_tagtype" pg_restore: creating TYPE "public.security_issues_releases_status" pg_restore: creating TYPE "public.security_issues_scope" pg_restore: creating FUNCTION "public.array_sort(anyarray)" pg_restore: creating FUNCTION "public.bibtex()" pg_restore: creating FUNCTION "public.bibtex_example_data()" pg_restore: creating FUNCTION "public.blends_metapackage_translations(text[])" pg_restore: creating FUNCTION "public.blends_query_packages(text[], text[], text)" pg_restore: creating FUNCTION "public.bugs_rt_affects_dist(text)" pg_restore: creating FUNCTION "public.ddtp_unique(text, text[])" pg_restore: creating FUNCTION "public.release_name(text)" pg_restore: creating FUNCTION "public.strip_binary_upload(text)" pg_restore: creating FUNCTION "public.versions_archs_component(text)" pg_restore: creating AGGREGATE "public.array_accum(anyelement)" pg_restore: creating TABLE "history.sources_count" pg_restore: creating TABLE "public.sources" pg_restore: creating TABLE "public.uploaders" pg_restore: creating TABLE "public.carnivore_keys" pg_restore: creating TABLE "public.carnivore_login" pg_restore: creating VIEW "public.active_dds" pg_restore: creating TABLE "public.archived_bugs" pg_restore: creating TABLE "public.bugs" pg_restore: creating VIEW "public.all_bugs" pg_restore: creating TABLE "public.derivatives_packages" pg_restore: creating TABLE "public.packages" pg_restore: creating TABLE "public.ubuntu_packages" pg_restore: creating VIEW "public.all_packages" pg_restore: creating TABLE "public.derivatives_packages_distrelcomparch" pg_restore: creating TABLE "public.packages_distrelcomparch" pg_restore: creating TABLE "public.ubuntu_packages_distrelcomparch" pg_restore: creating VIEW "public.all_packages_distrelcomparch" pg_restore: creating TABLE "public.derivatives_sources" pg_restore: creating TABLE "public.ubuntu_sources" pg_restore: creating VIEW "public.all_sources" pg_restore: creating TABLE "public.archived_bugs_blockedby" pg_restore: creating TABLE "public.archived_bugs_blocks" pg_restore: creating TABLE "public.archived_bugs_fixed_in" pg_restore: creating TABLE "public.archived_bugs_found_in" pg_restore: creating TABLE "public.archived_bugs_merged_with" pg_restore: creating TABLE "public.archived_bugs_packages" pg_restore: creating TABLE "public.archived_bugs_stamps" pg_restore: creating TABLE "public.archived_bugs_tags" pg_restore: creating TABLE "public.archived_descriptions" pg_restore: creating TABLE "public.archived_packages" pg_restore: creating TABLE "public.archived_packages_distrelcomparch" pg_restore: creating TABLE "public.archived_packages_summary" pg_restore: creating TABLE "public.archived_sources" pg_restore: creating TABLE "public.archived_uploaders" pg_restore: creating TABLE "public.bugs_merged_with" pg_restore: creating VIEW "public.bugs_count" pg_restore: creating TABLE "public.migrations" pg_restore: creating TABLE "public.orphaned_packages" pg_restore: creating TABLE "public.popcon_src" pg_restore: creating VIEW "public.sources_uniq" pg_restore: creating TABLE "public.upload_history" pg_restore: creating VIEW "public.upload_history_nmus" pg_restore: creating VIEW "public.bapase" pg_restore: creating TABLE "public.bibref" pg_restore: creating TABLE "public.blends_dependencies" pg_restore: creating TABLE "public.blends_dependencies_alternatives" pg_restore: creating TABLE "public.blends_dependencies_priorities" pg_restore: creating TABLE "public.blends_metadata" pg_restore: creating TABLE "public.blends_prospectivepackages" pg_restore: creating TABLE "public.blends_remarks" pg_restore: creating TABLE "public.blends_tasks" pg_restore: creating TABLE "public.blends_unknown_packages" pg_restore: creating TABLE "public.bts_tags" pg_restore: creating TABLE "public.bugs_blockedby" pg_restore: creating TABLE "public.bugs_blocks" pg_restore: creating TABLE "public.bugs_fixed_in" pg_restore: creating TABLE "public.bugs_found_in" pg_restore: creating TABLE "public.bugs_packages" pg_restore: creating VIEW "public.bugs_rt_affects_oldstable" pg_restore: creating VIEW "public.bugs_rt_affects_stable" pg_restore: creating VIEW "public.bugs_rt_affects_testing" pg_restore: creating VIEW "public.bugs_rt_affects_unstable" pg_restore: creating VIEW "public.bugs_rt_affects_testing_and_unstable" pg_restore: creating TABLE "public.bugs_stamps" pg_restore: creating TABLE "public.bugs_tags" pg_restore: creating TABLE "public.bugs_usertags" pg_restore: creating TABLE "public.carnivore_emails" pg_restore: creating TABLE "public.carnivore_names" pg_restore: creating TABLE "public.ci" pg_restore: creating TABLE "public.debian_maintainers" pg_restore: creating TABLE "public.debtags" pg_restore: creating TABLE "public.deferred" pg_restore: creating TABLE "public.deferred_architecture" pg_restore: creating TABLE "public.deferred_binary" pg_restore: creating TABLE "public.deferred_closes" pg_restore: creating TABLE "public.dehs" pg_restore: creating TABLE "public.derivatives_descriptions" pg_restore: creating TABLE "public.derivatives_packages_summary" pg_restore: creating TABLE "public.derivatives_uploaders" pg_restore: creating TABLE "public.description_imports" pg_restore: creating TABLE "public.descriptions" pg_restore: creating TABLE "public.duck" pg_restore: creating TABLE "public.edam" pg_restore: creating TABLE "public.ftp_autorejects" pg_restore: creating TABLE "public.hints" pg_restore: creating TABLE "public.key_packages" pg_restore: creating TABLE "public.lintian_results" pg_restore: creating MATERIALIZED VIEW "public.lintian_results_agg" pg_restore: creating MATERIALIZED VIEW "public.lintian" pg_restore: creating TABLE "public.lintian_logs" pg_restore: creating TABLE "public.lintian_tags_descriptions" pg_restore: creating TABLE "public.mentors_raw_uploads" pg_restore: creating VIEW "public.mentors_most_recent_package_versions" pg_restore: creating TABLE "public.migration_excuses" pg_restore: creating TABLE "public.new_packages" pg_restore: creating VIEW "public.new_packages_madison" pg_restore: creating TABLE "public.new_sources" pg_restore: creating VIEW "public.new_sources_madison" pg_restore: creating TABLE "public.package_removal" pg_restore: creating TABLE "public.package_removal_batch" pg_restore: creating TABLE "public.packages_summary" pg_restore: creating TABLE "public.patches" pg_restore: creating TABLE "public.patches_status" pg_restore: creating TABLE "public.piuparts_status" pg_restore: creating TABLE "public.popcon" pg_restore: creating TABLE "public.popcon_src_average" pg_restore: creating TABLE "public.ports_descriptions" pg_restore: creating TABLE "public.ports_packages" pg_restore: creating TABLE "public.ports_packages_distrelcomparch" pg_restore: creating TABLE "public.ports_packages_summary" pg_restore: creating TABLE "public.ports_sources" pg_restore: creating TABLE "public.ports_uploaders" pg_restore: creating TABLE "public.potential_bug_closures" pg_restore: creating TABLE "public.pseudo_packages" pg_restore: creating TABLE "public.registry" pg_restore: creating TABLE "public.releases" pg_restore: creating VIEW "public.relevant_hints" pg_restore: creating TABLE "public.reproducible" pg_restore: creating TABLE "public.screenshots" pg_restore: creating TABLE "public.security_issues" pg_restore: creating TABLE "public.security_issues_releases" pg_restore: creating TABLE "public.sources_files" pg_restore: creating VIEW "public.sources_patches" pg_restore: creating MATERIALIZED VIEW "public.sources_patches_status" pg_restore: creating VIEW "public.sources_popcon" pg_restore: creating VIEW "public.sources_redundant" pg_restore: creating VIEW "public.sponsorship_requests" pg_restore: creating TABLE "public.testing_autoremovals" pg_restore: creating TABLE "public.timestamps" pg_restore: creating SEQUENCE "public.timestamps_id_seq" pg_restore: creating SEQUENCE OWNED BY "public.timestamps_id_seq" pg_restore: creating TABLE "public.ubuntu_bugs" pg_restore: creating TABLE "public.ubuntu_bugs_duplicates" pg_restore: creating TABLE "public.ubuntu_bugs_subscribers" pg_restore: creating TABLE "public.ubuntu_bugs_tags" pg_restore: creating TABLE "public.ubuntu_bugs_tasks" pg_restore: creating TABLE "public.ubuntu_description_imports" pg_restore: creating TABLE "public.ubuntu_descriptions" pg_restore: creating TABLE "public.ubuntu_packages_summary" pg_restore: creating TABLE "public.ubuntu_popcon" pg_restore: creating TABLE "public.ubuntu_popcon_src" pg_restore: creating TABLE "public.ubuntu_popcon_src_average" pg_restore: creating VIEW "public.ubuntu_sources_popcon" pg_restore: creating TABLE "public.ubuntu_upload_history" pg_restore: creating TABLE "public.ubuntu_upload_history_closes" pg_restore: creating TABLE "public.ubuntu_upload_history_launchpad_closes" pg_restore: creating TABLE "public.ubuntu_uploaders" pg_restore: creating TABLE "public.udd_logs" pg_restore: creating TABLE "public.unofficial_descriptions" pg_restore: creating TABLE "public.unofficial_packages" pg_restore: creating TABLE "public.unofficial_packages_distrelcomparch" pg_restore: creating TABLE "public.unofficial_packages_summary" pg_restore: creating TABLE "public.unofficial_sources" pg_restore: creating TABLE "public.unofficial_uploaders" pg_restore: creating TABLE "public.upload_history_architecture" pg_restore: creating TABLE "public.upload_history_closes" pg_restore: creating TABLE "public.upstream" pg_restore: creating TABLE "public.upstream_metadata" pg_restore: creating TABLE "public.vcs" pg_restore: creating TABLE "public.vcswatch" pg_restore: creating TABLE "public.wannabuild" pg_restore: creating VIEW "public.wnpp" pg_restore: creating DEFAULT "public.timestamps id" pg_restore: processing data for table "history.sources_count" pg_restore: processing data for table "public.archived_bugs" pg_restore: processing data for table "public.archived_bugs_blockedby" pg_restore: processing data for table "public.archived_bugs_blocks" pg_restore: processing data for table "public.archived_bugs_fixed_in" pg_restore: processing data for table "public.archived_bugs_found_in" pg_restore: processing data for table "public.archived_bugs_merged_with" pg_restore: processing data for table "public.archived_bugs_packages" pg_restore: processing data for table "public.archived_bugs_stamps" pg_restore: processing data for table "public.archived_bugs_tags" pg_restore: processing data for table "public.archived_descriptions" pg_restore: processing data for table "public.archived_packages" pg_restore: processing data for table "public.archived_packages_distrelcomparch" pg_restore: processing data for table "public.archived_packages_summary" pg_restore: processing data for table "public.archived_sources" pg_restore: processing data for table "public.archived_uploaders" pg_restore: processing data for table "public.bibref" pg_restore: processing data for table "public.blends_dependencies" pg_restore: processing data for table "public.blends_dependencies_alternatives" pg_restore: processing data for table "public.blends_dependencies_priorities" pg_restore: processing data for table "public.blends_metadata" pg_restore: processing data for table "public.blends_prospectivepackages" pg_restore: processing data for table "public.blends_remarks" pg_restore: processing data for table "public.blends_tasks" pg_restore: processing data for table "public.blends_unknown_packages" pg_restore: processing data for table "public.bts_tags" pg_restore: processing data for table "public.bugs" pg_restore: processing data for table "public.bugs_blockedby" pg_restore: processing data for table "public.bugs_blocks" pg_restore: processing data for table "public.bugs_fixed_in" pg_restore: processing data for table "public.bugs_found_in" pg_restore: processing data for table "public.bugs_merged_with" pg_restore: processing data for table "public.bugs_packages" pg_restore: processing data for table "public.bugs_stamps" pg_restore: processing data for table "public.bugs_tags" pg_restore: processing data for table "public.bugs_usertags" pg_restore: processing data for table "public.carnivore_emails" pg_restore: processing data for table "public.carnivore_keys" pg_restore: processing data for table "public.carnivore_login" pg_restore: processing data for table "public.carnivore_names" pg_restore: processing data for table "public.ci" pg_restore: processing data for table "public.debian_maintainers" pg_restore: processing data for table "public.debtags" pg_restore: processing data for table "public.deferred" pg_restore: processing data for table "public.deferred_architecture" pg_restore: processing data for table "public.deferred_binary" pg_restore: processing data for table "public.deferred_closes" pg_restore: processing data for table "public.dehs" pg_restore: processing data for table "public.derivatives_descriptions" pg_restore: processing data for table "public.derivatives_packages" pg_restore: processing data for table "public.derivatives_packages_distrelcomparch" pg_restore: processing data for table "public.derivatives_packages_summary" pg_restore: processing data for table "public.derivatives_sources" pg_restore: processing data for table "public.derivatives_uploaders" pg_restore: processing data for table "public.description_imports" pg_restore: processing data for table "public.descriptions" pg_restore: processing data for table "public.duck" pg_restore: processing data for table "public.edam" pg_restore: processing data for table "public.ftp_autorejects" pg_restore: processing data for table "public.hints" pg_restore: processing data for table "public.key_packages" pg_restore: processing data for table "public.lintian_logs" pg_restore: processing data for table "public.lintian_results" pg_restore: processing data for table "public.lintian_tags_descriptions" pg_restore: processing data for table "public.mentors_raw_uploads" pg_restore: processing data for table "public.migration_excuses" pg_restore: processing data for table "public.migrations" pg_restore: processing data for table "public.new_packages" pg_restore: processing data for table "public.new_sources" pg_restore: processing data for table "public.orphaned_packages" pg_restore: processing data for table "public.package_removal" pg_restore: processing data for table "public.package_removal_batch" pg_restore: processing data for table "public.packages" pg_restore: processing data for table "public.packages_distrelcomparch" pg_restore: processing data for table "public.packages_summary" pg_restore: processing data for table "public.patches" pg_restore: processing data for table "public.patches_status" pg_restore: processing data for table "public.piuparts_status" pg_restore: processing data for table "public.popcon" pg_restore: processing data for table "public.popcon_src" pg_restore: processing data for table "public.popcon_src_average" pg_restore: processing data for table "public.ports_descriptions" pg_restore: processing data for table "public.ports_packages" pg_restore: processing data for table "public.ports_packages_distrelcomparch" pg_restore: processing data for table "public.ports_packages_summary" pg_restore: processing data for table "public.ports_sources" pg_restore: processing data for table "public.ports_uploaders" pg_restore: processing data for table "public.potential_bug_closures" pg_restore: processing data for table "public.pseudo_packages" pg_restore: processing data for table "public.registry" pg_restore: processing data for table "public.releases" pg_restore: processing data for table "public.reproducible" pg_restore: processing data for table "public.screenshots" pg_restore: processing data for table "public.security_issues" pg_restore: processing data for table "public.security_issues_releases" pg_restore: processing data for table "public.sources" pg_restore: processing data for table "public.sources_files" pg_restore: processing data for table "public.testing_autoremovals" pg_restore: processing data for table "public.timestamps" pg_restore: processing data for table "public.ubuntu_bugs" pg_restore: processing data for table "public.ubuntu_bugs_duplicates" pg_restore: processing data for table "public.ubuntu_bugs_subscribers" pg_restore: processing data for table "public.ubuntu_bugs_tags" pg_restore: processing data for table "public.ubuntu_bugs_tasks" pg_restore: processing data for table "public.ubuntu_description_imports" pg_restore: processing data for table "public.ubuntu_descriptions" pg_restore: processing data for table "public.ubuntu_packages" pg_restore: processing data for table "public.ubuntu_packages_distrelcomparch" pg_restore: processing data for table "public.ubuntu_packages_summary" pg_restore: processing data for table "public.ubuntu_popcon" pg_restore: processing data for table "public.ubuntu_popcon_src" pg_restore: processing data for table "public.ubuntu_popcon_src_average" pg_restore: processing data for table "public.ubuntu_sources" pg_restore: processing data for table "public.ubuntu_upload_history" pg_restore: processing data for table "public.ubuntu_upload_history_closes" pg_restore: processing data for table "public.ubuntu_upload_history_launchpad_closes" pg_restore: processing data for table "public.ubuntu_uploaders" pg_restore: processing data for table "public.udd_logs" pg_restore: processing data for table "public.unofficial_descriptions" pg_restore: processing data for table "public.unofficial_packages" pg_restore: processing data for table "public.unofficial_packages_distrelcomparch" pg_restore: processing data for table "public.unofficial_packages_summary" pg_restore: processing data for table "public.unofficial_sources" pg_restore: processing data for table "public.unofficial_uploaders" pg_restore: processing data for table "public.upload_history" pg_restore: processing data for table "public.upload_history_architecture" pg_restore: processing data for table "public.upload_history_closes" pg_restore: processing data for table "public.uploaders" pg_restore: processing data for table "public.upstream" pg_restore: processing data for table "public.upstream_metadata" pg_restore: processing data for table "public.vcs" pg_restore: processing data for table "public.vcswatch" pg_restore: processing data for table "public.wannabuild" pg_restore: executing SEQUENCE SET timestamps_id_seq pg_restore: creating CONSTRAINT "history.sources_count sources_count_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_blockedby archived_bugs_blockedby_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_blocks archived_bugs_blocks_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_fixed_in archived_bugs_fixed_in_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_found_in archived_bugs_found_in_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_merged_with archived_bugs_merged_with_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_packages archived_bugs_packages_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs archived_bugs_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_stamps archived_bugs_stamps_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_tags archived_bugs_tags_pkey" pg_restore: creating CONSTRAINT "public.archived_descriptions archived_descriptions_pkey" pg_restore: creating CONSTRAINT "public.archived_packages archived_packages_pkey" pg_restore: creating CONSTRAINT "public.archived_packages_summary archived_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.archived_sources archived_sources_pkey" pg_restore: creating CONSTRAINT "public.bibref bibref_pkey" pg_restore: creating CONSTRAINT "public.blends_dependencies_alternatives blends_dependencies_alternatives_pkey" pg_restore: creating CONSTRAINT "public.blends_dependencies blends_dependencies_pkey" pg_restore: creating CONSTRAINT "public.blends_metadata blends_metadata_pkey" pg_restore: creating CONSTRAINT "public.blends_prospectivepackages blends_prospectivepackages_pkey" pg_restore: creating CONSTRAINT "public.blends_remarks blends_remarks_pkey" pg_restore: creating CONSTRAINT "public.blends_tasks blends_tasks_pkey" pg_restore: creating CONSTRAINT "public.blends_unknown_packages blends_unknown_packages_pkey" pg_restore: creating CONSTRAINT "public.bugs_blockedby bugs_blockedby_pkey" pg_restore: creating CONSTRAINT "public.bugs_blocks bugs_blocks_pkey" pg_restore: creating CONSTRAINT "public.bugs_fixed_in bugs_fixed_in_pkey" pg_restore: creating CONSTRAINT "public.bugs_found_in bugs_found_in_pkey" pg_restore: creating CONSTRAINT "public.bugs_merged_with bugs_merged_with_pkey" pg_restore: creating CONSTRAINT "public.bugs_packages bugs_packages_pkey" pg_restore: creating CONSTRAINT "public.bugs bugs_pkey" pg_restore: creating CONSTRAINT "public.bugs_stamps bugs_stamps_pkey" pg_restore: creating CONSTRAINT "public.bugs_tags bugs_tags_pkey" pg_restore: creating CONSTRAINT "public.carnivore_emails carnivore_emails_pkey" pg_restore: creating CONSTRAINT "public.carnivore_keys carnivore_keys_pkey" pg_restore: creating CONSTRAINT "public.carnivore_login carnivore_login_pkey" pg_restore: creating CONSTRAINT "public.carnivore_names carnivore_names_pkey" pg_restore: creating CONSTRAINT "public.ci ci_pkey" pg_restore: creating CONSTRAINT "public.deferred_architecture deferred_architecture_pkey" pg_restore: creating CONSTRAINT "public.deferred_binary deferred_binary_pkey" pg_restore: creating CONSTRAINT "public.deferred_closes deferred_closes_pkey" pg_restore: creating CONSTRAINT "public.deferred deferred_pkey" pg_restore: creating CONSTRAINT "public.dehs dehs_pkey" pg_restore: creating CONSTRAINT "public.derivatives_descriptions derivatives_descriptions_pkey" pg_restore: creating CONSTRAINT "public.derivatives_packages derivatives_packages_pkey" pg_restore: creating CONSTRAINT "public.derivatives_packages_summary derivatives_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.derivatives_sources derivatives_sources_pkey" pg_restore: creating CONSTRAINT "public.description_imports description_imports_pkey" pg_restore: creating CONSTRAINT "public.descriptions descriptions_pkey" pg_restore: creating CONSTRAINT "public.duck duck_pkey" pg_restore: creating CONSTRAINT "public.edam edam_pkey" pg_restore: creating CONSTRAINT "public.ftp_autorejects ftp_autorejects_pkey" pg_restore: creating CONSTRAINT "public.key_packages key_packages_pkey" pg_restore: creating CONSTRAINT "public.mentors_raw_uploads mentors_raw_uploads_pkey" pg_restore: creating CONSTRAINT "public.migration_excuses migration_excuses_pkey" pg_restore: creating CONSTRAINT "public.migrations migrations_pkey" pg_restore: creating CONSTRAINT "public.new_packages new_packages_pkey" pg_restore: creating CONSTRAINT "public.new_sources new_sources_pkey" pg_restore: creating CONSTRAINT "public.orphaned_packages orphaned_packages_pkey" pg_restore: creating CONSTRAINT "public.package_removal_batch package_removal_batch_pkey" pg_restore: creating CONSTRAINT "public.package_removal package_removal_pkey" pg_restore: creating CONSTRAINT "public.packages packages_pkey" pg_restore: creating CONSTRAINT "public.packages_summary packages_summary_pkey" pg_restore: creating CONSTRAINT "public.popcon popcon_pkey" pg_restore: creating CONSTRAINT "public.popcon_src_average popcon_src_average_pkey" pg_restore: creating CONSTRAINT "public.popcon_src popcon_src_pkey" pg_restore: creating CONSTRAINT "public.ports_descriptions ports_descriptions_pkey" pg_restore: creating CONSTRAINT "public.ports_packages ports_packages_pkey" pg_restore: creating CONSTRAINT "public.ports_packages_summary ports_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.ports_sources ports_sources_pkey" pg_restore: creating CONSTRAINT "public.pseudo_packages pseudo_packages_pkey" pg_restore: creating CONSTRAINT "public.registry registry_pkey" pg_restore: creating CONSTRAINT "public.releases releases_pkey" pg_restore: creating CONSTRAINT "public.reproducible reproducible_pkey" pg_restore: creating CONSTRAINT "public.screenshots screenshots_pkey" pg_restore: creating CONSTRAINT "public.security_issues security_issues_pkey" pg_restore: creating CONSTRAINT "public.security_issues_releases security_issues_releases_pkey" pg_restore: creating CONSTRAINT "public.sources sources_pkey" pg_restore: creating CONSTRAINT "public.timestamps timestamps_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs_duplicates ubuntu_bugs_duplicates_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs ubuntu_bugs_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs_tags ubuntu_bugs_tags_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs_tasks ubuntu_bugs_tasks_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_description_imports ubuntu_description_imports_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_descriptions ubuntu_descriptions_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_packages ubuntu_packages_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_packages_summary ubuntu_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_popcon ubuntu_popcon_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_popcon_src_average ubuntu_popcon_src_average_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_popcon_src ubuntu_popcon_src_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_sources ubuntu_sources_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_upload_history_closes ubuntu_upload_history_closes_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_upload_history_launchpad_closes ubuntu_upload_history_launchpad_closes_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_upload_history ubuntu_upload_history_pkey" pg_restore: creating CONSTRAINT "public.udd_logs udd_logs_pkey" pg_restore: creating CONSTRAINT "public.unofficial_descriptions unofficial_descriptions_pkey" pg_restore: creating CONSTRAINT "public.unofficial_packages unofficial_packages_pkey" pg_restore: creating CONSTRAINT "public.unofficial_packages_summary unofficial_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.unofficial_sources unofficial_sources_pkey" pg_restore: creating CONSTRAINT "public.upload_history_architecture upload_history_architecture_pkey" pg_restore: creating CONSTRAINT "public.upload_history_closes upload_history_closes_pkey" pg_restore: creating CONSTRAINT "public.upload_history upload_history_pkey" pg_restore: creating CONSTRAINT "public.upstream_metadata upstream_metadata_pkey" pg_restore: creating CONSTRAINT "public.upstream upstream_pkey" pg_restore: creating CONSTRAINT "public.vcs vcs_pkey" pg_restore: creating CONSTRAINT "public.vcswatch vcswatch_pkey" pg_restore: creating CONSTRAINT "public.wannabuild wannabuild_pkey" pg_restore: creating INDEX "public.archived_packages_distrelcomp_idx" pg_restore: creating INDEX "public.archived_packages_source_idx" pg_restore: creating INDEX "public.archived_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.archived_sources_distrelcomp_idx" pg_restore: creating INDEX "public.archived_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.bugs_package_idx" pg_restore: creating INDEX "public.bugs_packages_package_idx" pg_restore: creating INDEX "public.bugs_packages_source_idx" pg_restore: creating INDEX "public.bugs_severity_idx" pg_restore: creating INDEX "public.bugs_source_idx" pg_restore: creating INDEX "public.bugs_tags_tag_idx" pg_restore: creating INDEX "public.carnivore_keys_id_idx" pg_restore: creating INDEX "public.debtags_package_idx" pg_restore: creating INDEX "public.debtags_tag_idx" pg_restore: creating INDEX "public.derivatives_packages_distrelcomp_idx" pg_restore: creating INDEX "public.derivatives_packages_source_idx" pg_restore: creating INDEX "public.derivatives_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.derivatives_sources_distrelcomp_idx" pg_restore: creating INDEX "public.derivatives_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.hints_idx" pg_restore: creating INDEX "public.lintian_logs_idx" pg_restore: creating INDEX "public.lintian_results_agg_idx" pg_restore: creating INDEX "public.lintian_results_agg_unique_idx" pg_restore: creating INDEX "public.lintian_results_idx" pg_restore: creating INDEX "public.lintian_results_packages_idx" pg_restore: creating INDEX "public.lintian_unique_idx" pg_restore: creating INDEX "public.packages_distrelcomp_idx" pg_restore: creating INDEX "public.packages_pkgverarchdistrelcomp_idx" pg_restore: creating INDEX "public.packages_pkgverdescr_idx" pg_restore: creating INDEX "public.packages_source_idx" pg_restore: creating INDEX "public.packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.piuparts_status_section_idx" pg_restore: creating INDEX "public.piuparts_status_source_idx" pg_restore: creating INDEX "public.piuparts_status_status_idx" pg_restore: creating INDEX "public.ports_packages_distrelcomp_idx" pg_restore: creating INDEX "public.ports_packages_source_idx" pg_restore: creating INDEX "public.ports_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.ports_sources_distrelcomp_idx" pg_restore: creating INDEX "public.ports_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.potential_bug_closures_id_idx" pg_restore: creating INDEX "public.potential_bug_closures_source_idx" pg_restore: creating INDEX "public.sources_distrelcomp_idx" pg_restore: creating INDEX "public.sources_release_idx" pg_restore: creating INDEX "public.testing_autoremovals_source_idx" pg_restore: creating INDEX "public.ubuntu_bugs_duplicates_idx" pg_restore: creating INDEX "public.ubuntu_bugs_subscribers_idx" pg_restore: creating INDEX "public.ubuntu_bugs_tags_idx" pg_restore: creating INDEX "public.ubuntu_bugs_tasks_idx" pg_restore: creating INDEX "public.ubuntu_bugs_tasks_package_idx" pg_restore: creating INDEX "public.ubuntu_packages_distrelcomp_idx" pg_restore: creating INDEX "public.ubuntu_packages_pkgverdescr_idx" pg_restore: creating INDEX "public.ubuntu_packages_source_idx" pg_restore: creating INDEX "public.ubuntu_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.ubuntu_sources_distrelcomp_idx" pg_restore: creating INDEX "public.ubuntu_sources_release_idx" pg_restore: creating INDEX "public.ubuntu_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.unofficial_packages_distrelcomp_idx" pg_restore: creating INDEX "public.unofficial_packages_source_idx" pg_restore: creating INDEX "public.unofficial_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.unofficial_sources_distrelcomp_idx" pg_restore: creating INDEX "public.unofficial_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.upload_history_distribution_date_idx" pg_restore: creating INDEX "public.upload_history_fingerprint_idx" pg_restore: creating INDEX "public.uploaders_distrelcompsrcver_idx" pg_restore: creating FK CONSTRAINT "public.archived_bugs_blockedby archived_bugs_blockedby_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_blocks archived_bugs_blocks_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_fixed_in archived_bugs_fixed_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_found_in archived_bugs_found_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_merged_with archived_bugs_merged_with_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_packages archived_bugs_packages_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_tags archived_bugs_tags_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_packages archived_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.blends_dependencies_alternatives blends_dependencies_alternatives_blend_fkey" pg_restore: creating FK CONSTRAINT "public.blends_dependencies blends_dependencies_blend_fkey" pg_restore: creating FK CONSTRAINT "public.blends_tasks blends_tasks_blend_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_blockedby bugs_blockedby_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_blocks bugs_blocks_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_fixed_in bugs_fixed_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_found_in bugs_found_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_merged_with bugs_merged_with_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_packages bugs_packages_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_tags bugs_tags_id_fkey" pg_restore: creating FK CONSTRAINT "public.deferred_architecture deferred_architecture_source_fkey" pg_restore: creating FK CONSTRAINT "public.deferred_binary deferred_binary_source_fkey" pg_restore: creating FK CONSTRAINT "public.deferred_closes deferred_closes_source_fkey" pg_restore: creating FK CONSTRAINT "public.derivatives_packages derivatives_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.package_removal package_removal_batch_id_fkey" pg_restore: creating FK CONSTRAINT "public.security_issues_releases security_issues_releases_source_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_duplicates ubuntu_bugs_duplicates_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_subscribers ubuntu_bugs_subscribers_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_tags ubuntu_bugs_tags_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_tasks ubuntu_bugs_tasks_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_packages ubuntu_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_upload_history_closes ubuntu_upload_history_closes_source_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_upload_history_launchpad_closes ubuntu_upload_history_launchpad_closes_source_fkey" pg_restore: creating FK CONSTRAINT "public.unofficial_packages unofficial_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.upload_history_architecture upload_history_architecture_source_fkey" pg_restore: creating FK CONSTRAINT "public.upload_history_closes upload_history_closes_source_fkey" pg_restore: creating ACL "SCHEMA history" pg_restore: creating ACL "SCHEMA public" pg_restore: creating ACL "public.TYPE bugs_severity" pg_restore: creating ACL "public.TYPE dehs_status" pg_restore: creating ACL "public.TYPE ftp_autoreject_level" pg_restore: creating ACL "public.TYPE ftp_autoreject_type" pg_restore: creating ACL "public.TYPE security_issues_releases_status" pg_restore: creating ACL "public.TYPE security_issues_scope" pg_restore: creating ACL "history.TABLE sources_count" pg_restore: creating ACL "public.TABLE sources" pg_restore: creating ACL "public.TABLE uploaders" pg_restore: creating ACL "public.TABLE carnivore_keys" pg_restore: creating ACL "public.TABLE carnivore_login" pg_restore: creating ACL "public.TABLE active_dds" pg_restore: creating ACL "public.TABLE archived_bugs" pg_restore: creating ACL "public.TABLE bugs" pg_restore: creating ACL "public.TABLE all_bugs" pg_restore: creating ACL "public.TABLE derivatives_packages" pg_restore: creating ACL "public.TABLE packages" pg_restore: creating ACL "public.TABLE ubuntu_packages" pg_restore: creating ACL "public.TABLE all_packages" pg_restore: creating ACL "public.TABLE derivatives_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE packages_distrelcomparch" pg_restore: creating ACL "public.TABLE ubuntu_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE all_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE derivatives_sources" pg_restore: creating ACL "public.TABLE ubuntu_sources" pg_restore: creating ACL "public.TABLE all_sources" pg_restore: creating ACL "public.TABLE archived_bugs_blockedby" pg_restore: creating ACL "public.TABLE archived_bugs_blocks" pg_restore: creating ACL "public.TABLE archived_bugs_fixed_in" pg_restore: creating ACL "public.TABLE archived_bugs_found_in" pg_restore: creating ACL "public.TABLE archived_bugs_merged_with" pg_restore: creating ACL "public.TABLE archived_bugs_packages" pg_restore: creating ACL "public.TABLE archived_bugs_stamps" pg_restore: creating ACL "public.TABLE archived_bugs_tags" pg_restore: creating ACL "public.TABLE archived_descriptions" pg_restore: creating ACL "public.TABLE archived_packages" pg_restore: creating ACL "public.TABLE archived_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE archived_packages_summary" pg_restore: creating ACL "public.TABLE archived_sources" pg_restore: creating ACL "public.TABLE archived_uploaders" pg_restore: creating ACL "public.TABLE bugs_merged_with" pg_restore: creating ACL "public.TABLE bugs_count" pg_restore: creating ACL "public.TABLE migrations" pg_restore: creating ACL "public.TABLE orphaned_packages" pg_restore: creating ACL "public.TABLE popcon_src" pg_restore: creating ACL "public.TABLE sources_uniq" pg_restore: creating ACL "public.TABLE upload_history" pg_restore: creating ACL "public.TABLE upload_history_nmus" pg_restore: creating ACL "public.TABLE bapase" pg_restore: creating ACL "public.TABLE bibref" pg_restore: creating ACL "public.TABLE blends_dependencies" pg_restore: creating ACL "public.TABLE blends_dependencies_alternatives" pg_restore: creating ACL "public.TABLE blends_dependencies_priorities" pg_restore: creating ACL "public.TABLE blends_metadata" pg_restore: creating ACL "public.TABLE blends_prospectivepackages" pg_restore: creating ACL "public.TABLE blends_remarks" pg_restore: creating ACL "public.TABLE blends_tasks" pg_restore: creating ACL "public.TABLE blends_unknown_packages" pg_restore: creating ACL "public.TABLE bts_tags" pg_restore: creating ACL "public.TABLE bugs_blockedby" pg_restore: creating ACL "public.TABLE bugs_blocks" pg_restore: creating ACL "public.TABLE bugs_fixed_in" pg_restore: creating ACL "public.TABLE bugs_found_in" pg_restore: creating ACL "public.TABLE bugs_packages" pg_restore: creating ACL "public.TABLE bugs_rt_affects_oldstable" pg_restore: creating ACL "public.TABLE bugs_rt_affects_stable" pg_restore: creating ACL "public.TABLE bugs_rt_affects_testing" pg_restore: creating ACL "public.TABLE bugs_rt_affects_unstable" pg_restore: creating ACL "public.TABLE bugs_rt_affects_testing_and_unstable" pg_restore: creating ACL "public.TABLE bugs_stamps" pg_restore: creating ACL "public.TABLE bugs_tags" pg_restore: creating ACL "public.TABLE bugs_usertags" pg_restore: creating ACL "public.TABLE carnivore_emails" pg_restore: creating ACL "public.TABLE carnivore_names" pg_restore: creating ACL "public.TABLE ci" pg_restore: creating ACL "public.TABLE debian_maintainers" pg_restore: creating ACL "public.TABLE debtags" pg_restore: creating ACL "public.TABLE deferred" pg_restore: creating ACL "public.TABLE deferred_architecture" pg_restore: creating ACL "public.TABLE deferred_binary" pg_restore: creating ACL "public.TABLE deferred_closes" pg_restore: creating ACL "public.TABLE dehs" pg_restore: creating ACL "public.TABLE derivatives_descriptions" pg_restore: creating ACL "public.TABLE derivatives_packages_summary" pg_restore: creating ACL "public.TABLE derivatives_uploaders" pg_restore: creating ACL "public.TABLE description_imports" pg_restore: creating ACL "public.TABLE descriptions" pg_restore: creating ACL "public.TABLE duck" pg_restore: creating ACL "public.TABLE edam" pg_restore: creating ACL "public.TABLE ftp_autorejects" pg_restore: creating ACL "public.TABLE hints" pg_restore: creating ACL "public.TABLE key_packages" pg_restore: creating ACL "public.TABLE lintian_results" pg_restore: creating ACL "public.TABLE lintian_results_agg" pg_restore: creating ACL "public.TABLE lintian" pg_restore: creating ACL "public.TABLE lintian_logs" pg_restore: creating ACL "public.TABLE lintian_tags_descriptions" pg_restore: creating ACL "public.TABLE mentors_raw_uploads" pg_restore: creating ACL "public.TABLE mentors_most_recent_package_versions" pg_restore: creating ACL "public.TABLE migration_excuses" pg_restore: creating ACL "public.TABLE new_packages" pg_restore: creating ACL "public.TABLE new_packages_madison" pg_restore: creating ACL "public.TABLE new_sources" pg_restore: creating ACL "public.TABLE new_sources_madison" pg_restore: creating ACL "public.TABLE package_removal" pg_restore: creating ACL "public.TABLE package_removal_batch" pg_restore: creating ACL "public.TABLE packages_summary" pg_restore: creating ACL "public.TABLE patches" pg_restore: creating ACL "public.TABLE patches_status" pg_restore: creating ACL "public.TABLE piuparts_status" pg_restore: creating ACL "public.TABLE popcon" pg_restore: creating ACL "public.TABLE popcon_src_average" pg_restore: creating ACL "public.TABLE ports_descriptions" pg_restore: creating ACL "public.TABLE ports_packages" pg_restore: creating ACL "public.TABLE ports_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE ports_packages_summary" pg_restore: creating ACL "public.TABLE ports_sources" pg_restore: creating ACL "public.TABLE ports_uploaders" pg_restore: creating ACL "public.TABLE potential_bug_closures" pg_restore: creating ACL "public.TABLE pseudo_packages" pg_restore: creating ACL "public.TABLE registry" pg_restore: creating ACL "public.TABLE releases" pg_restore: creating ACL "public.TABLE relevant_hints" pg_restore: creating ACL "public.TABLE reproducible" pg_restore: creating ACL "public.TABLE screenshots" pg_restore: creating ACL "public.TABLE security_issues" pg_restore: creating ACL "public.TABLE security_issues_releases" pg_restore: creating ACL "public.TABLE sources_files" pg_restore: creating ACL "public.TABLE sources_patches" pg_restore: creating ACL "public.TABLE sources_patches_status" pg_restore: creating ACL "public.TABLE sources_popcon" pg_restore: creating ACL "public.TABLE sources_redundant" pg_restore: creating ACL "public.TABLE sponsorship_requests" pg_restore: creating ACL "public.TABLE testing_autoremovals" pg_restore: creating ACL "public.TABLE timestamps" pg_restore: creating ACL "public.SEQUENCE timestamps_id_seq" pg_restore: creating ACL "public.TABLE ubuntu_bugs" pg_restore: creating ACL "public.TABLE ubuntu_bugs_duplicates" pg_restore: creating ACL "public.TABLE ubuntu_bugs_subscribers" pg_restore: creating ACL "public.TABLE ubuntu_bugs_tags" pg_restore: creating ACL "public.TABLE ubuntu_bugs_tasks" pg_restore: creating ACL "public.TABLE ubuntu_description_imports" pg_restore: creating ACL "public.TABLE ubuntu_descriptions" pg_restore: creating ACL "public.TABLE ubuntu_packages_summary" pg_restore: creating ACL "public.TABLE ubuntu_popcon" pg_restore: creating ACL "public.TABLE ubuntu_popcon_src" pg_restore: creating ACL "public.TABLE ubuntu_popcon_src_average" pg_restore: creating ACL "public.TABLE ubuntu_sources_popcon" pg_restore: creating ACL "public.TABLE ubuntu_upload_history" pg_restore: creating ACL "public.TABLE ubuntu_upload_history_closes" pg_restore: creating ACL "public.TABLE ubuntu_upload_history_launchpad_closes" pg_restore: creating ACL "public.TABLE ubuntu_uploaders" pg_restore: creating ACL "public.TABLE udd_logs" pg_restore: creating ACL "public.TABLE unofficial_descriptions" pg_restore: creating ACL "public.TABLE unofficial_packages" pg_restore: creating ACL "public.TABLE unofficial_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE unofficial_packages_summary" pg_restore: creating ACL "public.TABLE unofficial_sources" pg_restore: creating ACL "public.TABLE unofficial_uploaders" pg_restore: creating ACL "public.TABLE upload_history_architecture" pg_restore: creating ACL "public.TABLE upload_history_closes" pg_restore: creating ACL "public.TABLE upstream" pg_restore: creating ACL "public.TABLE upstream_metadata" pg_restore: creating ACL "public.TABLE vcs" pg_restore: creating ACL "public.TABLE vcswatch" pg_restore: creating ACL "public.TABLE wannabuild" pg_restore: creating ACL "public.TABLE wnpp" pg_restore: creating MATERIALIZED VIEW DATA "public.lintian_results_agg" pg_restore: creating MATERIALIZED VIEW DATA "public.lintian" pg_restore: creating MATERIALIZED VIEW DATA "public.sources_patches_status" REVOKE CONNECT ON DATABASE udd_20240328_547894 FROM public REVOKE SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd_20240328_547894' pg_terminate_backend ---------------------- (0 rows) Created udd_20240328_547894. REVOKE CONNECT ON DATABASE udd FROM public REVOKE SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd' pg_terminate_backend ---------------------- t t t (3 rows) SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd' pg_terminate_backend ---------------------- (0 rows) SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd_20240328_547894' pg_terminate_backend ---------------------- (0 rows) ALTER DATABASE "udd_20240328_547894" RENAME TO udd ALTER DATABASE GRANT CONNECT ON DATABASE udd TO public GRANT GRANT select ON ALL TABLES IN SCHEMA public TO "public-udd-mirror"; GRANT GRANT select ON ALL TABLES IN SCHEMA public TO "udd-mirror"; GRANT Thu Mar 28 03:58:23 UTC 2024: UDD mirror successfully updated! Releasing lock. removed '/tmp/update_udd.udd-mirror.lock' ============================================================================= Log started at Thu Mar 28 04:05:01 UTC 2024 lock taken at /tmp/update_udd.udd-mirror.lock Downloading udd.dump The database is already up-to-date, doing nothing. Releasing lock. removed '/tmp/update_udd.udd-mirror.lock' ============================================================================= Log started at Thu Mar 28 06:05:01 UTC 2024 lock taken at /tmp/update_udd.udd-mirror.lock Downloading udd.dump The database is already up-to-date, doing nothing. Releasing lock. removed '/tmp/update_udd.udd-mirror.lock' ============================================================================= Log started at Thu Mar 28 08:05:01 UTC 2024 lock taken at /tmp/update_udd.udd-mirror.lock Downloading udd.dump 2024-03-28 08:07:32 URL:https://udd.debian.org/dumps/udd.dump [2431420104/2431420104] -> "udd.dump" [1] ALTER DEFAULT PRIVILEGES FOR USER "udd" IN SCHEMA "public" GRANT SELECT ON TABLES TO "udd"; ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES FOR USER "udd-mirror" IN SCHEMA "public" GRANT SELECT ON TABLES TO "udd-mirror"; ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES FOR USER "public-udd-mirror" IN SCHEMA "public" GRANT SELECT ON TABLES TO "public-udd-mirror"; ALTER DEFAULT PRIVILEGES CREATE EXTENSION debversion CREATE EXTENSION pg_restore: connecting to database for restore pg_restore: creating SCHEMA "history" pg_restore: creating EXTENSION "debversion" pg_restore: creating COMMENT "EXTENSION debversion" pg_restore: creating TYPE "public.bugs_severity" pg_restore: creating TYPE "public.dehs_status" pg_restore: creating TYPE "public.ftp_autoreject_level" pg_restore: creating TYPE "public.ftp_autoreject_type" pg_restore: creating TYPE "public.lintian_tagtype" pg_restore: creating TYPE "public.security_issues_releases_status" pg_restore: creating TYPE "public.security_issues_scope" pg_restore: creating FUNCTION "public.array_sort(anyarray)" pg_restore: creating FUNCTION "public.bibtex()" pg_restore: creating FUNCTION "public.bibtex_example_data()" pg_restore: creating FUNCTION "public.blends_metapackage_translations(text[])" pg_restore: creating FUNCTION "public.blends_query_packages(text[], text[], text)" pg_restore: creating FUNCTION "public.bugs_rt_affects_dist(text)" pg_restore: creating FUNCTION "public.ddtp_unique(text, text[])" pg_restore: creating FUNCTION "public.release_name(text)" pg_restore: creating FUNCTION "public.strip_binary_upload(text)" pg_restore: creating FUNCTION "public.versions_archs_component(text)" pg_restore: creating AGGREGATE "public.array_accum(anyelement)" pg_restore: creating TABLE "history.sources_count" pg_restore: creating TABLE "public.sources" pg_restore: creating TABLE "public.uploaders" pg_restore: creating TABLE "public.carnivore_keys" pg_restore: creating TABLE "public.carnivore_login" pg_restore: creating VIEW "public.active_dds" pg_restore: creating TABLE "public.archived_bugs" pg_restore: creating TABLE "public.bugs" pg_restore: creating VIEW "public.all_bugs" pg_restore: creating TABLE "public.derivatives_packages" pg_restore: creating TABLE "public.packages" pg_restore: creating TABLE "public.ubuntu_packages" pg_restore: creating VIEW "public.all_packages" pg_restore: creating TABLE "public.derivatives_packages_distrelcomparch" pg_restore: creating TABLE "public.packages_distrelcomparch" pg_restore: creating TABLE "public.ubuntu_packages_distrelcomparch" pg_restore: creating VIEW "public.all_packages_distrelcomparch" pg_restore: creating TABLE "public.derivatives_sources" pg_restore: creating TABLE "public.ubuntu_sources" pg_restore: creating VIEW "public.all_sources" pg_restore: creating TABLE "public.archived_bugs_blockedby" pg_restore: creating TABLE "public.archived_bugs_blocks" pg_restore: creating TABLE "public.archived_bugs_fixed_in" pg_restore: creating TABLE "public.archived_bugs_found_in" pg_restore: creating TABLE "public.archived_bugs_merged_with" pg_restore: creating TABLE "public.archived_bugs_packages" pg_restore: creating TABLE "public.archived_bugs_stamps" pg_restore: creating TABLE "public.archived_bugs_tags" pg_restore: creating TABLE "public.archived_descriptions" pg_restore: creating TABLE "public.archived_packages" pg_restore: creating TABLE "public.archived_packages_distrelcomparch" pg_restore: creating TABLE "public.archived_packages_summary" pg_restore: creating TABLE "public.archived_sources" pg_restore: creating TABLE "public.archived_uploaders" pg_restore: creating TABLE "public.bugs_merged_with" pg_restore: creating VIEW "public.bugs_count" pg_restore: creating TABLE "public.migrations" pg_restore: creating TABLE "public.orphaned_packages" pg_restore: creating TABLE "public.popcon_src" pg_restore: creating VIEW "public.sources_uniq" pg_restore: creating TABLE "public.upload_history" pg_restore: creating VIEW "public.upload_history_nmus" pg_restore: creating VIEW "public.bapase" pg_restore: creating TABLE "public.bibref" pg_restore: creating TABLE "public.blends_dependencies" pg_restore: creating TABLE "public.blends_dependencies_alternatives" pg_restore: creating TABLE "public.blends_dependencies_priorities" pg_restore: creating TABLE "public.blends_metadata" pg_restore: creating TABLE "public.blends_prospectivepackages" pg_restore: creating TABLE "public.blends_remarks" pg_restore: creating TABLE "public.blends_tasks" pg_restore: creating TABLE "public.blends_unknown_packages" pg_restore: creating TABLE "public.bts_tags" pg_restore: creating TABLE "public.bugs_blockedby" pg_restore: creating TABLE "public.bugs_blocks" pg_restore: creating TABLE "public.bugs_fixed_in" pg_restore: creating TABLE "public.bugs_found_in" pg_restore: creating TABLE "public.bugs_packages" pg_restore: creating VIEW "public.bugs_rt_affects_oldstable" pg_restore: creating VIEW "public.bugs_rt_affects_stable" pg_restore: creating VIEW "public.bugs_rt_affects_testing" pg_restore: creating VIEW "public.bugs_rt_affects_unstable" pg_restore: creating VIEW "public.bugs_rt_affects_testing_and_unstable" pg_restore: creating TABLE "public.bugs_stamps" pg_restore: creating TABLE "public.bugs_tags" pg_restore: creating TABLE "public.bugs_usertags" pg_restore: creating TABLE "public.carnivore_emails" pg_restore: creating TABLE "public.carnivore_names" pg_restore: creating TABLE "public.ci" pg_restore: creating TABLE "public.debian_maintainers" pg_restore: creating TABLE "public.debtags" pg_restore: creating TABLE "public.deferred" pg_restore: creating TABLE "public.deferred_architecture" pg_restore: creating TABLE "public.deferred_binary" pg_restore: creating TABLE "public.deferred_closes" pg_restore: creating TABLE "public.dehs" pg_restore: creating TABLE "public.derivatives_descriptions" pg_restore: creating TABLE "public.derivatives_packages_summary" pg_restore: creating TABLE "public.derivatives_uploaders" pg_restore: creating TABLE "public.description_imports" pg_restore: creating TABLE "public.descriptions" pg_restore: creating TABLE "public.duck" pg_restore: creating TABLE "public.edam" pg_restore: creating TABLE "public.ftp_autorejects" pg_restore: creating TABLE "public.hints" pg_restore: creating TABLE "public.key_packages" pg_restore: creating TABLE "public.lintian_results" pg_restore: creating MATERIALIZED VIEW "public.lintian_results_agg" pg_restore: creating MATERIALIZED VIEW "public.lintian" pg_restore: creating TABLE "public.lintian_logs" pg_restore: creating TABLE "public.lintian_tags_descriptions" pg_restore: creating TABLE "public.mentors_raw_uploads" pg_restore: creating VIEW "public.mentors_most_recent_package_versions" pg_restore: creating TABLE "public.migration_excuses" pg_restore: creating TABLE "public.new_packages" pg_restore: creating VIEW "public.new_packages_madison" pg_restore: creating TABLE "public.new_sources" pg_restore: creating VIEW "public.new_sources_madison" pg_restore: creating TABLE "public.package_removal" pg_restore: creating TABLE "public.package_removal_batch" pg_restore: creating TABLE "public.packages_summary" pg_restore: creating TABLE "public.patches" pg_restore: creating TABLE "public.patches_status" pg_restore: creating TABLE "public.piuparts_status" pg_restore: creating TABLE "public.popcon" pg_restore: creating TABLE "public.popcon_src_average" pg_restore: creating TABLE "public.ports_descriptions" pg_restore: creating TABLE "public.ports_packages" pg_restore: creating TABLE "public.ports_packages_distrelcomparch" pg_restore: creating TABLE "public.ports_packages_summary" pg_restore: creating TABLE "public.ports_sources" pg_restore: creating TABLE "public.ports_uploaders" pg_restore: creating TABLE "public.potential_bug_closures" pg_restore: creating TABLE "public.pseudo_packages" pg_restore: creating TABLE "public.registry" pg_restore: creating TABLE "public.releases" pg_restore: creating VIEW "public.relevant_hints" pg_restore: creating TABLE "public.reproducible" pg_restore: creating TABLE "public.screenshots" pg_restore: creating TABLE "public.security_issues" pg_restore: creating TABLE "public.security_issues_releases" pg_restore: creating TABLE "public.sources_files" pg_restore: creating VIEW "public.sources_patches" pg_restore: creating MATERIALIZED VIEW "public.sources_patches_status" pg_restore: creating VIEW "public.sources_popcon" pg_restore: creating VIEW "public.sources_redundant" pg_restore: creating VIEW "public.sponsorship_requests" pg_restore: creating TABLE "public.testing_autoremovals" pg_restore: creating TABLE "public.timestamps" pg_restore: creating SEQUENCE "public.timestamps_id_seq" pg_restore: creating SEQUENCE OWNED BY "public.timestamps_id_seq" pg_restore: creating TABLE "public.ubuntu_bugs" pg_restore: creating TABLE "public.ubuntu_bugs_duplicates" pg_restore: creating TABLE "public.ubuntu_bugs_subscribers" pg_restore: creating TABLE "public.ubuntu_bugs_tags" pg_restore: creating TABLE "public.ubuntu_bugs_tasks" pg_restore: creating TABLE "public.ubuntu_description_imports" pg_restore: creating TABLE "public.ubuntu_descriptions" pg_restore: creating TABLE "public.ubuntu_packages_summary" pg_restore: creating TABLE "public.ubuntu_popcon" pg_restore: creating TABLE "public.ubuntu_popcon_src" pg_restore: creating TABLE "public.ubuntu_popcon_src_average" pg_restore: creating VIEW "public.ubuntu_sources_popcon" pg_restore: creating TABLE "public.ubuntu_upload_history" pg_restore: creating TABLE "public.ubuntu_upload_history_closes" pg_restore: creating TABLE "public.ubuntu_upload_history_launchpad_closes" pg_restore: creating TABLE "public.ubuntu_uploaders" pg_restore: creating TABLE "public.udd_logs" pg_restore: creating TABLE "public.unofficial_descriptions" pg_restore: creating TABLE "public.unofficial_packages" pg_restore: creating TABLE "public.unofficial_packages_distrelcomparch" pg_restore: creating TABLE "public.unofficial_packages_summary" pg_restore: creating TABLE "public.unofficial_sources" pg_restore: creating TABLE "public.unofficial_uploaders" pg_restore: creating TABLE "public.upload_history_architecture" pg_restore: creating TABLE "public.upload_history_closes" pg_restore: creating TABLE "public.upstream" pg_restore: creating TABLE "public.upstream_metadata" pg_restore: creating TABLE "public.vcs" pg_restore: creating TABLE "public.vcswatch" pg_restore: creating TABLE "public.wannabuild" pg_restore: creating VIEW "public.wnpp" pg_restore: creating DEFAULT "public.timestamps id" pg_restore: processing data for table "history.sources_count" pg_restore: processing data for table "public.archived_bugs" pg_restore: processing data for table "public.archived_bugs_blockedby" pg_restore: processing data for table "public.archived_bugs_blocks" pg_restore: processing data for table "public.archived_bugs_fixed_in" pg_restore: processing data for table "public.archived_bugs_found_in" pg_restore: processing data for table "public.archived_bugs_merged_with" pg_restore: processing data for table "public.archived_bugs_packages" pg_restore: processing data for table "public.archived_bugs_stamps" pg_restore: processing data for table "public.archived_bugs_tags" pg_restore: processing data for table "public.archived_descriptions" pg_restore: processing data for table "public.archived_packages" pg_restore: processing data for table "public.archived_packages_distrelcomparch" pg_restore: processing data for table "public.archived_packages_summary" pg_restore: processing data for table "public.archived_sources" pg_restore: processing data for table "public.archived_uploaders" pg_restore: processing data for table "public.bibref" pg_restore: processing data for table "public.blends_dependencies" pg_restore: processing data for table "public.blends_dependencies_alternatives" pg_restore: processing data for table "public.blends_dependencies_priorities" pg_restore: processing data for table "public.blends_metadata" pg_restore: processing data for table "public.blends_prospectivepackages" pg_restore: processing data for table "public.blends_remarks" pg_restore: processing data for table "public.blends_tasks" pg_restore: processing data for table "public.blends_unknown_packages" pg_restore: processing data for table "public.bts_tags" pg_restore: processing data for table "public.bugs" pg_restore: processing data for table "public.bugs_blockedby" pg_restore: processing data for table "public.bugs_blocks" pg_restore: processing data for table "public.bugs_fixed_in" pg_restore: processing data for table "public.bugs_found_in" pg_restore: processing data for table "public.bugs_merged_with" pg_restore: processing data for table "public.bugs_packages" pg_restore: processing data for table "public.bugs_stamps" pg_restore: processing data for table "public.bugs_tags" pg_restore: processing data for table "public.bugs_usertags" pg_restore: processing data for table "public.carnivore_emails" pg_restore: processing data for table "public.carnivore_keys" pg_restore: processing data for table "public.carnivore_login" pg_restore: processing data for table "public.carnivore_names" pg_restore: processing data for table "public.ci" pg_restore: processing data for table "public.debian_maintainers" pg_restore: processing data for table "public.debtags" pg_restore: processing data for table "public.deferred" pg_restore: processing data for table "public.deferred_architecture" pg_restore: processing data for table "public.deferred_binary" pg_restore: processing data for table "public.deferred_closes" pg_restore: processing data for table "public.dehs" pg_restore: processing data for table "public.derivatives_descriptions" pg_restore: processing data for table "public.derivatives_packages" pg_restore: processing data for table "public.derivatives_packages_distrelcomparch" pg_restore: processing data for table "public.derivatives_packages_summary" pg_restore: processing data for table "public.derivatives_sources" pg_restore: processing data for table "public.derivatives_uploaders" pg_restore: processing data for table "public.description_imports" pg_restore: processing data for table "public.descriptions" pg_restore: processing data for table "public.duck" pg_restore: processing data for table "public.edam" pg_restore: processing data for table "public.ftp_autorejects" pg_restore: processing data for table "public.hints" pg_restore: processing data for table "public.key_packages" pg_restore: processing data for table "public.lintian_logs" pg_restore: processing data for table "public.lintian_results" pg_restore: processing data for table "public.lintian_tags_descriptions" pg_restore: processing data for table "public.mentors_raw_uploads" pg_restore: processing data for table "public.migration_excuses" pg_restore: processing data for table "public.migrations" pg_restore: processing data for table "public.new_packages" pg_restore: processing data for table "public.new_sources" pg_restore: processing data for table "public.orphaned_packages" pg_restore: processing data for table "public.package_removal" pg_restore: processing data for table "public.package_removal_batch" pg_restore: processing data for table "public.packages" pg_restore: processing data for table "public.packages_distrelcomparch" pg_restore: processing data for table "public.packages_summary" pg_restore: processing data for table "public.patches" pg_restore: processing data for table "public.patches_status" pg_restore: processing data for table "public.piuparts_status" pg_restore: processing data for table "public.popcon" pg_restore: processing data for table "public.popcon_src" pg_restore: processing data for table "public.popcon_src_average" pg_restore: processing data for table "public.ports_descriptions" pg_restore: processing data for table "public.ports_packages" pg_restore: processing data for table "public.ports_packages_distrelcomparch" pg_restore: processing data for table "public.ports_packages_summary" pg_restore: processing data for table "public.ports_sources" pg_restore: processing data for table "public.ports_uploaders" pg_restore: processing data for table "public.potential_bug_closures" pg_restore: processing data for table "public.pseudo_packages" pg_restore: processing data for table "public.registry" pg_restore: processing data for table "public.releases" pg_restore: processing data for table "public.reproducible" pg_restore: processing data for table "public.screenshots" pg_restore: processing data for table "public.security_issues" pg_restore: processing data for table "public.security_issues_releases" pg_restore: processing data for table "public.sources" pg_restore: processing data for table "public.sources_files" pg_restore: processing data for table "public.testing_autoremovals" pg_restore: processing data for table "public.timestamps" pg_restore: processing data for table "public.ubuntu_bugs" pg_restore: processing data for table "public.ubuntu_bugs_duplicates" pg_restore: processing data for table "public.ubuntu_bugs_subscribers" pg_restore: processing data for table "public.ubuntu_bugs_tags" pg_restore: processing data for table "public.ubuntu_bugs_tasks" pg_restore: processing data for table "public.ubuntu_description_imports" pg_restore: processing data for table "public.ubuntu_descriptions" pg_restore: processing data for table "public.ubuntu_packages" pg_restore: processing data for table "public.ubuntu_packages_distrelcomparch" pg_restore: processing data for table "public.ubuntu_packages_summary" pg_restore: processing data for table "public.ubuntu_popcon" pg_restore: processing data for table "public.ubuntu_popcon_src" pg_restore: processing data for table "public.ubuntu_popcon_src_average" pg_restore: processing data for table "public.ubuntu_sources" pg_restore: processing data for table "public.ubuntu_upload_history" pg_restore: processing data for table "public.ubuntu_upload_history_closes" pg_restore: processing data for table "public.ubuntu_upload_history_launchpad_closes" pg_restore: processing data for table "public.ubuntu_uploaders" pg_restore: processing data for table "public.udd_logs" pg_restore: processing data for table "public.unofficial_descriptions" pg_restore: processing data for table "public.unofficial_packages" pg_restore: processing data for table "public.unofficial_packages_distrelcomparch" pg_restore: processing data for table "public.unofficial_packages_summary" pg_restore: processing data for table "public.unofficial_sources" pg_restore: processing data for table "public.unofficial_uploaders" pg_restore: processing data for table "public.upload_history" pg_restore: processing data for table "public.upload_history_architecture" pg_restore: processing data for table "public.upload_history_closes" pg_restore: processing data for table "public.uploaders" pg_restore: processing data for table "public.upstream" pg_restore: processing data for table "public.upstream_metadata" pg_restore: processing data for table "public.vcs" pg_restore: processing data for table "public.vcswatch" pg_restore: processing data for table "public.wannabuild" pg_restore: executing SEQUENCE SET timestamps_id_seq pg_restore: creating CONSTRAINT "history.sources_count sources_count_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_blockedby archived_bugs_blockedby_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_blocks archived_bugs_blocks_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_fixed_in archived_bugs_fixed_in_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_found_in archived_bugs_found_in_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_merged_with archived_bugs_merged_with_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_packages archived_bugs_packages_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs archived_bugs_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_stamps archived_bugs_stamps_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_tags archived_bugs_tags_pkey" pg_restore: creating CONSTRAINT "public.archived_descriptions archived_descriptions_pkey" pg_restore: creating CONSTRAINT "public.archived_packages archived_packages_pkey" pg_restore: creating CONSTRAINT "public.archived_packages_summary archived_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.archived_sources archived_sources_pkey" pg_restore: creating CONSTRAINT "public.bibref bibref_pkey" pg_restore: creating CONSTRAINT "public.blends_dependencies_alternatives blends_dependencies_alternatives_pkey" pg_restore: creating CONSTRAINT "public.blends_dependencies blends_dependencies_pkey" pg_restore: creating CONSTRAINT "public.blends_metadata blends_metadata_pkey" pg_restore: creating CONSTRAINT "public.blends_prospectivepackages blends_prospectivepackages_pkey" pg_restore: creating CONSTRAINT "public.blends_remarks blends_remarks_pkey" pg_restore: creating CONSTRAINT "public.blends_tasks blends_tasks_pkey" pg_restore: creating CONSTRAINT "public.blends_unknown_packages blends_unknown_packages_pkey" pg_restore: creating CONSTRAINT "public.bugs_blockedby bugs_blockedby_pkey" pg_restore: creating CONSTRAINT "public.bugs_blocks bugs_blocks_pkey" pg_restore: creating CONSTRAINT "public.bugs_fixed_in bugs_fixed_in_pkey" pg_restore: creating CONSTRAINT "public.bugs_found_in bugs_found_in_pkey" pg_restore: creating CONSTRAINT "public.bugs_merged_with bugs_merged_with_pkey" pg_restore: creating CONSTRAINT "public.bugs_packages bugs_packages_pkey" pg_restore: creating CONSTRAINT "public.bugs bugs_pkey" pg_restore: creating CONSTRAINT "public.bugs_stamps bugs_stamps_pkey" pg_restore: creating CONSTRAINT "public.bugs_tags bugs_tags_pkey" pg_restore: creating CONSTRAINT "public.carnivore_emails carnivore_emails_pkey" pg_restore: creating CONSTRAINT "public.carnivore_keys carnivore_keys_pkey" pg_restore: creating CONSTRAINT "public.carnivore_login carnivore_login_pkey" pg_restore: creating CONSTRAINT "public.carnivore_names carnivore_names_pkey" pg_restore: creating CONSTRAINT "public.ci ci_pkey" pg_restore: creating CONSTRAINT "public.deferred_architecture deferred_architecture_pkey" pg_restore: creating CONSTRAINT "public.deferred_binary deferred_binary_pkey" pg_restore: creating CONSTRAINT "public.deferred_closes deferred_closes_pkey" pg_restore: creating CONSTRAINT "public.deferred deferred_pkey" pg_restore: creating CONSTRAINT "public.dehs dehs_pkey" pg_restore: creating CONSTRAINT "public.derivatives_descriptions derivatives_descriptions_pkey" pg_restore: creating CONSTRAINT "public.derivatives_packages derivatives_packages_pkey" pg_restore: creating CONSTRAINT "public.derivatives_packages_summary derivatives_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.derivatives_sources derivatives_sources_pkey" pg_restore: creating CONSTRAINT "public.description_imports description_imports_pkey" pg_restore: creating CONSTRAINT "public.descriptions descriptions_pkey" pg_restore: creating CONSTRAINT "public.duck duck_pkey" pg_restore: creating CONSTRAINT "public.edam edam_pkey" pg_restore: creating CONSTRAINT "public.ftp_autorejects ftp_autorejects_pkey" pg_restore: creating CONSTRAINT "public.key_packages key_packages_pkey" pg_restore: creating CONSTRAINT "public.mentors_raw_uploads mentors_raw_uploads_pkey" pg_restore: creating CONSTRAINT "public.migration_excuses migration_excuses_pkey" pg_restore: creating CONSTRAINT "public.migrations migrations_pkey" pg_restore: creating CONSTRAINT "public.new_packages new_packages_pkey" pg_restore: creating CONSTRAINT "public.new_sources new_sources_pkey" pg_restore: creating CONSTRAINT "public.orphaned_packages orphaned_packages_pkey" pg_restore: creating CONSTRAINT "public.package_removal_batch package_removal_batch_pkey" pg_restore: creating CONSTRAINT "public.package_removal package_removal_pkey" pg_restore: creating CONSTRAINT "public.packages packages_pkey" pg_restore: creating CONSTRAINT "public.packages_summary packages_summary_pkey" pg_restore: creating CONSTRAINT "public.popcon popcon_pkey" pg_restore: creating CONSTRAINT "public.popcon_src_average popcon_src_average_pkey" pg_restore: creating CONSTRAINT "public.popcon_src popcon_src_pkey" pg_restore: creating CONSTRAINT "public.ports_descriptions ports_descriptions_pkey" pg_restore: creating CONSTRAINT "public.ports_packages ports_packages_pkey" pg_restore: creating CONSTRAINT "public.ports_packages_summary ports_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.ports_sources ports_sources_pkey" pg_restore: creating CONSTRAINT "public.pseudo_packages pseudo_packages_pkey" pg_restore: creating CONSTRAINT "public.registry registry_pkey" pg_restore: creating CONSTRAINT "public.releases releases_pkey" pg_restore: creating CONSTRAINT "public.reproducible reproducible_pkey" pg_restore: creating CONSTRAINT "public.screenshots screenshots_pkey" pg_restore: creating CONSTRAINT "public.security_issues security_issues_pkey" pg_restore: creating CONSTRAINT "public.security_issues_releases security_issues_releases_pkey" pg_restore: creating CONSTRAINT "public.sources sources_pkey" pg_restore: creating CONSTRAINT "public.timestamps timestamps_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs_duplicates ubuntu_bugs_duplicates_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs ubuntu_bugs_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs_tags ubuntu_bugs_tags_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs_tasks ubuntu_bugs_tasks_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_description_imports ubuntu_description_imports_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_descriptions ubuntu_descriptions_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_packages ubuntu_packages_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_packages_summary ubuntu_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_popcon ubuntu_popcon_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_popcon_src_average ubuntu_popcon_src_average_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_popcon_src ubuntu_popcon_src_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_sources ubuntu_sources_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_upload_history_closes ubuntu_upload_history_closes_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_upload_history_launchpad_closes ubuntu_upload_history_launchpad_closes_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_upload_history ubuntu_upload_history_pkey" pg_restore: creating CONSTRAINT "public.udd_logs udd_logs_pkey" pg_restore: creating CONSTRAINT "public.unofficial_descriptions unofficial_descriptions_pkey" pg_restore: creating CONSTRAINT "public.unofficial_packages unofficial_packages_pkey" pg_restore: creating CONSTRAINT "public.unofficial_packages_summary unofficial_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.unofficial_sources unofficial_sources_pkey" pg_restore: creating CONSTRAINT "public.upload_history_architecture upload_history_architecture_pkey" pg_restore: creating CONSTRAINT "public.upload_history_closes upload_history_closes_pkey" pg_restore: creating CONSTRAINT "public.upload_history upload_history_pkey" pg_restore: creating CONSTRAINT "public.upstream_metadata upstream_metadata_pkey" pg_restore: creating CONSTRAINT "public.upstream upstream_pkey" pg_restore: creating CONSTRAINT "public.vcs vcs_pkey" pg_restore: creating CONSTRAINT "public.vcswatch vcswatch_pkey" pg_restore: creating CONSTRAINT "public.wannabuild wannabuild_pkey" pg_restore: creating INDEX "public.archived_packages_distrelcomp_idx" pg_restore: creating INDEX "public.archived_packages_source_idx" pg_restore: creating INDEX "public.archived_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.archived_sources_distrelcomp_idx" pg_restore: creating INDEX "public.archived_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.bugs_package_idx" pg_restore: creating INDEX "public.bugs_packages_package_idx" pg_restore: creating INDEX "public.bugs_packages_source_idx" pg_restore: creating INDEX "public.bugs_severity_idx" pg_restore: creating INDEX "public.bugs_source_idx" pg_restore: creating INDEX "public.bugs_tags_tag_idx" pg_restore: creating INDEX "public.carnivore_keys_id_idx" pg_restore: creating INDEX "public.debtags_package_idx" pg_restore: creating INDEX "public.debtags_tag_idx" pg_restore: creating INDEX "public.derivatives_packages_distrelcomp_idx" pg_restore: creating INDEX "public.derivatives_packages_source_idx" pg_restore: creating INDEX "public.derivatives_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.derivatives_sources_distrelcomp_idx" pg_restore: creating INDEX "public.derivatives_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.hints_idx" pg_restore: creating INDEX "public.lintian_logs_idx" pg_restore: creating INDEX "public.lintian_results_agg_idx" pg_restore: creating INDEX "public.lintian_results_agg_unique_idx" pg_restore: creating INDEX "public.lintian_results_idx" pg_restore: creating INDEX "public.lintian_results_packages_idx" pg_restore: creating INDEX "public.lintian_unique_idx" pg_restore: creating INDEX "public.packages_distrelcomp_idx" pg_restore: creating INDEX "public.packages_pkgverarchdistrelcomp_idx" pg_restore: creating INDEX "public.packages_pkgverdescr_idx" pg_restore: creating INDEX "public.packages_source_idx" pg_restore: creating INDEX "public.packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.piuparts_status_section_idx" pg_restore: creating INDEX "public.piuparts_status_source_idx" pg_restore: creating INDEX "public.piuparts_status_status_idx" pg_restore: creating INDEX "public.ports_packages_distrelcomp_idx" pg_restore: creating INDEX "public.ports_packages_source_idx" pg_restore: creating INDEX "public.ports_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.ports_sources_distrelcomp_idx" pg_restore: creating INDEX "public.ports_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.potential_bug_closures_id_idx" pg_restore: creating INDEX "public.potential_bug_closures_source_idx" pg_restore: creating INDEX "public.sources_distrelcomp_idx" pg_restore: creating INDEX "public.sources_release_idx" pg_restore: creating INDEX "public.testing_autoremovals_source_idx" pg_restore: creating INDEX "public.ubuntu_bugs_duplicates_idx" pg_restore: creating INDEX "public.ubuntu_bugs_subscribers_idx" pg_restore: creating INDEX "public.ubuntu_bugs_tags_idx" pg_restore: creating INDEX "public.ubuntu_bugs_tasks_idx" pg_restore: creating INDEX "public.ubuntu_bugs_tasks_package_idx" pg_restore: creating INDEX "public.ubuntu_packages_distrelcomp_idx" pg_restore: creating INDEX "public.ubuntu_packages_pkgverdescr_idx" pg_restore: creating INDEX "public.ubuntu_packages_source_idx" pg_restore: creating INDEX "public.ubuntu_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.ubuntu_sources_distrelcomp_idx" pg_restore: creating INDEX "public.ubuntu_sources_release_idx" pg_restore: creating INDEX "public.ubuntu_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.unofficial_packages_distrelcomp_idx" pg_restore: creating INDEX "public.unofficial_packages_source_idx" pg_restore: creating INDEX "public.unofficial_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.unofficial_sources_distrelcomp_idx" pg_restore: creating INDEX "public.unofficial_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.upload_history_distribution_date_idx" pg_restore: creating INDEX "public.upload_history_fingerprint_idx" pg_restore: creating INDEX "public.uploaders_distrelcompsrcver_idx" pg_restore: creating FK CONSTRAINT "public.archived_bugs_blockedby archived_bugs_blockedby_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_blocks archived_bugs_blocks_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_fixed_in archived_bugs_fixed_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_found_in archived_bugs_found_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_merged_with archived_bugs_merged_with_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_packages archived_bugs_packages_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_tags archived_bugs_tags_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_packages archived_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.blends_dependencies_alternatives blends_dependencies_alternatives_blend_fkey" pg_restore: creating FK CONSTRAINT "public.blends_dependencies blends_dependencies_blend_fkey" pg_restore: creating FK CONSTRAINT "public.blends_tasks blends_tasks_blend_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_blockedby bugs_blockedby_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_blocks bugs_blocks_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_fixed_in bugs_fixed_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_found_in bugs_found_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_merged_with bugs_merged_with_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_packages bugs_packages_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_tags bugs_tags_id_fkey" pg_restore: creating FK CONSTRAINT "public.deferred_architecture deferred_architecture_source_fkey" pg_restore: creating FK CONSTRAINT "public.deferred_binary deferred_binary_source_fkey" pg_restore: creating FK CONSTRAINT "public.deferred_closes deferred_closes_source_fkey" pg_restore: creating FK CONSTRAINT "public.derivatives_packages derivatives_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.package_removal package_removal_batch_id_fkey" pg_restore: creating FK CONSTRAINT "public.security_issues_releases security_issues_releases_source_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_duplicates ubuntu_bugs_duplicates_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_subscribers ubuntu_bugs_subscribers_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_tags ubuntu_bugs_tags_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_tasks ubuntu_bugs_tasks_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_packages ubuntu_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_upload_history_closes ubuntu_upload_history_closes_source_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_upload_history_launchpad_closes ubuntu_upload_history_launchpad_closes_source_fkey" pg_restore: creating FK CONSTRAINT "public.unofficial_packages unofficial_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.upload_history_architecture upload_history_architecture_source_fkey" pg_restore: creating FK CONSTRAINT "public.upload_history_closes upload_history_closes_source_fkey" pg_restore: creating ACL "SCHEMA history" pg_restore: creating ACL "SCHEMA public" pg_restore: creating ACL "public.TYPE bugs_severity" pg_restore: creating ACL "public.TYPE dehs_status" pg_restore: creating ACL "public.TYPE ftp_autoreject_level" pg_restore: creating ACL "public.TYPE ftp_autoreject_type" pg_restore: creating ACL "public.TYPE security_issues_releases_status" pg_restore: creating ACL "public.TYPE security_issues_scope" pg_restore: creating ACL "history.TABLE sources_count" pg_restore: creating ACL "public.TABLE sources" pg_restore: creating ACL "public.TABLE uploaders" pg_restore: creating ACL "public.TABLE carnivore_keys" pg_restore: creating ACL "public.TABLE carnivore_login" pg_restore: creating ACL "public.TABLE active_dds" pg_restore: creating ACL "public.TABLE archived_bugs" pg_restore: creating ACL "public.TABLE bugs" pg_restore: creating ACL "public.TABLE all_bugs" pg_restore: creating ACL "public.TABLE derivatives_packages" pg_restore: creating ACL "public.TABLE packages" pg_restore: creating ACL "public.TABLE ubuntu_packages" pg_restore: creating ACL "public.TABLE all_packages" pg_restore: creating ACL "public.TABLE derivatives_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE packages_distrelcomparch" pg_restore: creating ACL "public.TABLE ubuntu_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE all_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE derivatives_sources" pg_restore: creating ACL "public.TABLE ubuntu_sources" pg_restore: creating ACL "public.TABLE all_sources" pg_restore: creating ACL "public.TABLE archived_bugs_blockedby" pg_restore: creating ACL "public.TABLE archived_bugs_blocks" pg_restore: creating ACL "public.TABLE archived_bugs_fixed_in" pg_restore: creating ACL "public.TABLE archived_bugs_found_in" pg_restore: creating ACL "public.TABLE archived_bugs_merged_with" pg_restore: creating ACL "public.TABLE archived_bugs_packages" pg_restore: creating ACL "public.TABLE archived_bugs_stamps" pg_restore: creating ACL "public.TABLE archived_bugs_tags" pg_restore: creating ACL "public.TABLE archived_descriptions" pg_restore: creating ACL "public.TABLE archived_packages" pg_restore: creating ACL "public.TABLE archived_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE archived_packages_summary" pg_restore: creating ACL "public.TABLE archived_sources" pg_restore: creating ACL "public.TABLE archived_uploaders" pg_restore: creating ACL "public.TABLE bugs_merged_with" pg_restore: creating ACL "public.TABLE bugs_count" pg_restore: creating ACL "public.TABLE migrations" pg_restore: creating ACL "public.TABLE orphaned_packages" pg_restore: creating ACL "public.TABLE popcon_src" pg_restore: creating ACL "public.TABLE sources_uniq" pg_restore: creating ACL "public.TABLE upload_history" pg_restore: creating ACL "public.TABLE upload_history_nmus" pg_restore: creating ACL "public.TABLE bapase" pg_restore: creating ACL "public.TABLE bibref" pg_restore: creating ACL "public.TABLE blends_dependencies" pg_restore: creating ACL "public.TABLE blends_dependencies_alternatives" pg_restore: creating ACL "public.TABLE blends_dependencies_priorities" pg_restore: creating ACL "public.TABLE blends_metadata" pg_restore: creating ACL "public.TABLE blends_prospectivepackages" pg_restore: creating ACL "public.TABLE blends_remarks" pg_restore: creating ACL "public.TABLE blends_tasks" pg_restore: creating ACL "public.TABLE blends_unknown_packages" pg_restore: creating ACL "public.TABLE bts_tags" pg_restore: creating ACL "public.TABLE bugs_blockedby" pg_restore: creating ACL "public.TABLE bugs_blocks" pg_restore: creating ACL "public.TABLE bugs_fixed_in" pg_restore: creating ACL "public.TABLE bugs_found_in" pg_restore: creating ACL "public.TABLE bugs_packages" pg_restore: creating ACL "public.TABLE bugs_rt_affects_oldstable" pg_restore: creating ACL "public.TABLE bugs_rt_affects_stable" pg_restore: creating ACL "public.TABLE bugs_rt_affects_testing" pg_restore: creating ACL "public.TABLE bugs_rt_affects_unstable" pg_restore: creating ACL "public.TABLE bugs_rt_affects_testing_and_unstable" pg_restore: creating ACL "public.TABLE bugs_stamps" pg_restore: creating ACL "public.TABLE bugs_tags" pg_restore: creating ACL "public.TABLE bugs_usertags" pg_restore: creating ACL "public.TABLE carnivore_emails" pg_restore: creating ACL "public.TABLE carnivore_names" pg_restore: creating ACL "public.TABLE ci" pg_restore: creating ACL "public.TABLE debian_maintainers" pg_restore: creating ACL "public.TABLE debtags" pg_restore: creating ACL "public.TABLE deferred" pg_restore: creating ACL "public.TABLE deferred_architecture" pg_restore: creating ACL "public.TABLE deferred_binary" pg_restore: creating ACL "public.TABLE deferred_closes" pg_restore: creating ACL "public.TABLE dehs" pg_restore: creating ACL "public.TABLE derivatives_descriptions" pg_restore: creating ACL "public.TABLE derivatives_packages_summary" pg_restore: creating ACL "public.TABLE derivatives_uploaders" pg_restore: creating ACL "public.TABLE description_imports" pg_restore: creating ACL "public.TABLE descriptions" pg_restore: creating ACL "public.TABLE duck" pg_restore: creating ACL "public.TABLE edam" pg_restore: creating ACL "public.TABLE ftp_autorejects" pg_restore: creating ACL "public.TABLE hints" pg_restore: creating ACL "public.TABLE key_packages" pg_restore: creating ACL "public.TABLE lintian_results" pg_restore: creating ACL "public.TABLE lintian_results_agg" pg_restore: creating ACL "public.TABLE lintian" pg_restore: creating ACL "public.TABLE lintian_logs" pg_restore: creating ACL "public.TABLE lintian_tags_descriptions" pg_restore: creating ACL "public.TABLE mentors_raw_uploads" pg_restore: creating ACL "public.TABLE mentors_most_recent_package_versions" pg_restore: creating ACL "public.TABLE migration_excuses" pg_restore: creating ACL "public.TABLE new_packages" pg_restore: creating ACL "public.TABLE new_packages_madison" pg_restore: creating ACL "public.TABLE new_sources" pg_restore: creating ACL "public.TABLE new_sources_madison" pg_restore: creating ACL "public.TABLE package_removal" pg_restore: creating ACL "public.TABLE package_removal_batch" pg_restore: creating ACL "public.TABLE packages_summary" pg_restore: creating ACL "public.TABLE patches" pg_restore: creating ACL "public.TABLE patches_status" pg_restore: creating ACL "public.TABLE piuparts_status" pg_restore: creating ACL "public.TABLE popcon" pg_restore: creating ACL "public.TABLE popcon_src_average" pg_restore: creating ACL "public.TABLE ports_descriptions" pg_restore: creating ACL "public.TABLE ports_packages" pg_restore: creating ACL "public.TABLE ports_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE ports_packages_summary" pg_restore: creating ACL "public.TABLE ports_sources" pg_restore: creating ACL "public.TABLE ports_uploaders" pg_restore: creating ACL "public.TABLE potential_bug_closures" pg_restore: creating ACL "public.TABLE pseudo_packages" pg_restore: creating ACL "public.TABLE registry" pg_restore: creating ACL "public.TABLE releases" pg_restore: creating ACL "public.TABLE relevant_hints" pg_restore: creating ACL "public.TABLE reproducible" pg_restore: creating ACL "public.TABLE screenshots" pg_restore: creating ACL "public.TABLE security_issues" pg_restore: creating ACL "public.TABLE security_issues_releases" pg_restore: creating ACL "public.TABLE sources_files" pg_restore: creating ACL "public.TABLE sources_patches" pg_restore: creating ACL "public.TABLE sources_patches_status" pg_restore: creating ACL "public.TABLE sources_popcon" pg_restore: creating ACL "public.TABLE sources_redundant" pg_restore: creating ACL "public.TABLE sponsorship_requests" pg_restore: creating ACL "public.TABLE testing_autoremovals" pg_restore: creating ACL "public.TABLE timestamps" pg_restore: creating ACL "public.SEQUENCE timestamps_id_seq" pg_restore: creating ACL "public.TABLE ubuntu_bugs" pg_restore: creating ACL "public.TABLE ubuntu_bugs_duplicates" pg_restore: creating ACL "public.TABLE ubuntu_bugs_subscribers" pg_restore: creating ACL "public.TABLE ubuntu_bugs_tags" pg_restore: creating ACL "public.TABLE ubuntu_bugs_tasks" pg_restore: creating ACL "public.TABLE ubuntu_description_imports" pg_restore: creating ACL "public.TABLE ubuntu_descriptions" pg_restore: creating ACL "public.TABLE ubuntu_packages_summary" pg_restore: creating ACL "public.TABLE ubuntu_popcon" pg_restore: creating ACL "public.TABLE ubuntu_popcon_src" pg_restore: creating ACL "public.TABLE ubuntu_popcon_src_average" pg_restore: creating ACL "public.TABLE ubuntu_sources_popcon" pg_restore: creating ACL "public.TABLE ubuntu_upload_history" pg_restore: creating ACL "public.TABLE ubuntu_upload_history_closes" pg_restore: creating ACL "public.TABLE ubuntu_upload_history_launchpad_closes" pg_restore: creating ACL "public.TABLE ubuntu_uploaders" pg_restore: creating ACL "public.TABLE udd_logs" pg_restore: creating ACL "public.TABLE unofficial_descriptions" pg_restore: creating ACL "public.TABLE unofficial_packages" pg_restore: creating ACL "public.TABLE unofficial_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE unofficial_packages_summary" pg_restore: creating ACL "public.TABLE unofficial_sources" pg_restore: creating ACL "public.TABLE unofficial_uploaders" pg_restore: creating ACL "public.TABLE upload_history_architecture" pg_restore: creating ACL "public.TABLE upload_history_closes" pg_restore: creating ACL "public.TABLE upstream" pg_restore: creating ACL "public.TABLE upstream_metadata" pg_restore: creating ACL "public.TABLE vcs" pg_restore: creating ACL "public.TABLE vcswatch" pg_restore: creating ACL "public.TABLE wannabuild" pg_restore: creating ACL "public.TABLE wnpp" pg_restore: creating MATERIALIZED VIEW DATA "public.lintian_results_agg" pg_restore: creating MATERIALIZED VIEW DATA "public.lintian" pg_restore: creating MATERIALIZED VIEW DATA "public.sources_patches_status" REVOKE CONNECT ON DATABASE udd_20240328_549541 FROM public REVOKE SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd_20240328_549541' pg_terminate_backend ---------------------- (0 rows) Created udd_20240328_549541. REVOKE CONNECT ON DATABASE udd FROM public REVOKE SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd' pg_terminate_backend ---------------------- (0 rows) SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd' pg_terminate_backend ---------------------- (0 rows) SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd_20240328_549541' pg_terminate_backend ---------------------- (0 rows) ALTER DATABASE "udd_20240328_549541" RENAME TO udd ALTER DATABASE GRANT CONNECT ON DATABASE udd TO public GRANT GRANT select ON ALL TABLES IN SCHEMA public TO "public-udd-mirror"; GRANT GRANT select ON ALL TABLES IN SCHEMA public TO "udd-mirror"; GRANT Thu Mar 28 09:55:01 UTC 2024: UDD mirror successfully updated! Releasing lock. removed '/tmp/update_udd.udd-mirror.lock' ============================================================================= Log started at Thu Mar 28 10:05:01 UTC 2024 lock taken at /tmp/update_udd.udd-mirror.lock Downloading udd.dump The database is already up-to-date, doing nothing. Releasing lock. removed '/tmp/update_udd.udd-mirror.lock' ============================================================================= Log started at Thu Mar 28 12:05:01 UTC 2024 lock taken at /tmp/update_udd.udd-mirror.lock Downloading udd.dump The database is already up-to-date, doing nothing. Releasing lock. removed '/tmp/update_udd.udd-mirror.lock' ============================================================================= Log started at Thu Mar 28 14:05:01 UTC 2024 lock taken at /tmp/update_udd.udd-mirror.lock Downloading udd.dump 2024-03-28 14:07:39 URL:https://udd.debian.org/dumps/udd.dump [2416607951/2416607951] -> "udd.dump" [1] ALTER DEFAULT PRIVILEGES FOR USER "udd" IN SCHEMA "public" GRANT SELECT ON TABLES TO "udd"; ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES FOR USER "udd-mirror" IN SCHEMA "public" GRANT SELECT ON TABLES TO "udd-mirror"; ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES FOR USER "public-udd-mirror" IN SCHEMA "public" GRANT SELECT ON TABLES TO "public-udd-mirror"; ALTER DEFAULT PRIVILEGES CREATE EXTENSION debversion CREATE EXTENSION pg_restore: connecting to database for restore pg_restore: creating SCHEMA "history" pg_restore: creating EXTENSION "debversion" pg_restore: creating COMMENT "EXTENSION debversion" pg_restore: creating TYPE "public.bugs_severity" pg_restore: creating TYPE "public.dehs_status" pg_restore: creating TYPE "public.ftp_autoreject_level" pg_restore: creating TYPE "public.ftp_autoreject_type" pg_restore: creating TYPE "public.lintian_tagtype" pg_restore: creating TYPE "public.security_issues_releases_status" pg_restore: creating TYPE "public.security_issues_scope" pg_restore: creating FUNCTION "public.array_sort(anyarray)" pg_restore: creating FUNCTION "public.bibtex()" pg_restore: creating FUNCTION "public.bibtex_example_data()" pg_restore: creating FUNCTION "public.blends_metapackage_translations(text[])" pg_restore: creating FUNCTION "public.blends_query_packages(text[], text[], text)" pg_restore: creating FUNCTION "public.bugs_rt_affects_dist(text)" pg_restore: creating FUNCTION "public.ddtp_unique(text, text[])" pg_restore: creating FUNCTION "public.release_name(text)" pg_restore: creating FUNCTION "public.strip_binary_upload(text)" pg_restore: creating FUNCTION "public.versions_archs_component(text)" pg_restore: creating AGGREGATE "public.array_accum(anyelement)" pg_restore: creating TABLE "history.sources_count" pg_restore: creating TABLE "public.sources" pg_restore: creating TABLE "public.uploaders" pg_restore: creating TABLE "public.carnivore_keys" pg_restore: creating TABLE "public.carnivore_login" pg_restore: creating VIEW "public.active_dds" pg_restore: creating TABLE "public.archived_bugs" pg_restore: creating TABLE "public.bugs" pg_restore: creating VIEW "public.all_bugs" pg_restore: creating TABLE "public.derivatives_packages" pg_restore: creating TABLE "public.packages" pg_restore: creating TABLE "public.ubuntu_packages" pg_restore: creating VIEW "public.all_packages" pg_restore: creating TABLE "public.derivatives_packages_distrelcomparch" pg_restore: creating TABLE "public.packages_distrelcomparch" pg_restore: creating TABLE "public.ubuntu_packages_distrelcomparch" pg_restore: creating VIEW "public.all_packages_distrelcomparch" pg_restore: creating TABLE "public.derivatives_sources" pg_restore: creating TABLE "public.ubuntu_sources" pg_restore: creating VIEW "public.all_sources" pg_restore: creating TABLE "public.archived_bugs_blockedby" pg_restore: creating TABLE "public.archived_bugs_blocks" pg_restore: creating TABLE "public.archived_bugs_fixed_in" pg_restore: creating TABLE "public.archived_bugs_found_in" pg_restore: creating TABLE "public.archived_bugs_merged_with" pg_restore: creating TABLE "public.archived_bugs_packages" pg_restore: creating TABLE "public.archived_bugs_stamps" pg_restore: creating TABLE "public.archived_bugs_tags" pg_restore: creating TABLE "public.archived_descriptions" pg_restore: creating TABLE "public.archived_packages" pg_restore: creating TABLE "public.archived_packages_distrelcomparch" pg_restore: creating TABLE "public.archived_packages_summary" pg_restore: creating TABLE "public.archived_sources" pg_restore: creating TABLE "public.archived_uploaders" pg_restore: creating TABLE "public.bugs_merged_with" pg_restore: creating VIEW "public.bugs_count" pg_restore: creating TABLE "public.migrations" pg_restore: creating TABLE "public.orphaned_packages" pg_restore: creating TABLE "public.popcon_src" pg_restore: creating VIEW "public.sources_uniq" pg_restore: creating TABLE "public.upload_history" pg_restore: creating VIEW "public.upload_history_nmus" pg_restore: creating VIEW "public.bapase" pg_restore: creating TABLE "public.bibref" pg_restore: creating TABLE "public.blends_dependencies" pg_restore: creating TABLE "public.blends_dependencies_alternatives" pg_restore: creating TABLE "public.blends_dependencies_priorities" pg_restore: creating TABLE "public.blends_metadata" pg_restore: creating TABLE "public.blends_prospectivepackages" pg_restore: creating TABLE "public.blends_remarks" pg_restore: creating TABLE "public.blends_tasks" pg_restore: creating TABLE "public.blends_unknown_packages" pg_restore: creating TABLE "public.bts_tags" pg_restore: creating TABLE "public.bugs_blockedby" pg_restore: creating TABLE "public.bugs_blocks" pg_restore: creating TABLE "public.bugs_fixed_in" pg_restore: creating TABLE "public.bugs_found_in" pg_restore: creating TABLE "public.bugs_packages" pg_restore: creating VIEW "public.bugs_rt_affects_oldstable" pg_restore: creating VIEW "public.bugs_rt_affects_stable" pg_restore: creating VIEW "public.bugs_rt_affects_testing" pg_restore: creating VIEW "public.bugs_rt_affects_unstable" pg_restore: creating VIEW "public.bugs_rt_affects_testing_and_unstable" pg_restore: creating TABLE "public.bugs_stamps" pg_restore: creating TABLE "public.bugs_tags" pg_restore: creating TABLE "public.bugs_usertags" pg_restore: creating TABLE "public.carnivore_emails" pg_restore: creating TABLE "public.carnivore_names" pg_restore: creating TABLE "public.ci" pg_restore: creating TABLE "public.debian_maintainers" pg_restore: creating TABLE "public.debtags" pg_restore: creating TABLE "public.deferred" pg_restore: creating TABLE "public.deferred_architecture" pg_restore: creating TABLE "public.deferred_binary" pg_restore: creating TABLE "public.deferred_closes" pg_restore: creating TABLE "public.dehs" pg_restore: creating TABLE "public.derivatives_descriptions" pg_restore: creating TABLE "public.derivatives_packages_summary" pg_restore: creating TABLE "public.derivatives_uploaders" pg_restore: creating TABLE "public.description_imports" pg_restore: creating TABLE "public.descriptions" pg_restore: creating TABLE "public.duck" pg_restore: creating TABLE "public.edam" pg_restore: creating TABLE "public.ftp_autorejects" pg_restore: creating TABLE "public.hints" pg_restore: creating TABLE "public.key_packages" pg_restore: creating TABLE "public.lintian_results" pg_restore: creating MATERIALIZED VIEW "public.lintian_results_agg" pg_restore: creating MATERIALIZED VIEW "public.lintian" pg_restore: creating TABLE "public.lintian_logs" pg_restore: creating TABLE "public.lintian_tags_descriptions" pg_restore: creating TABLE "public.mentors_raw_uploads" pg_restore: creating VIEW "public.mentors_most_recent_package_versions" pg_restore: creating TABLE "public.migration_excuses" pg_restore: creating TABLE "public.new_packages" pg_restore: creating VIEW "public.new_packages_madison" pg_restore: creating TABLE "public.new_sources" pg_restore: creating VIEW "public.new_sources_madison" pg_restore: creating TABLE "public.package_removal" pg_restore: creating TABLE "public.package_removal_batch" pg_restore: creating TABLE "public.packages_summary" pg_restore: creating TABLE "public.patches" pg_restore: creating TABLE "public.patches_status" pg_restore: creating TABLE "public.piuparts_status" pg_restore: creating TABLE "public.popcon" pg_restore: creating TABLE "public.popcon_src_average" pg_restore: creating TABLE "public.ports_descriptions" pg_restore: creating TABLE "public.ports_packages" pg_restore: creating TABLE "public.ports_packages_distrelcomparch" pg_restore: creating TABLE "public.ports_packages_summary" pg_restore: creating TABLE "public.ports_sources" pg_restore: creating TABLE "public.ports_uploaders" pg_restore: creating TABLE "public.potential_bug_closures" pg_restore: creating TABLE "public.pseudo_packages" pg_restore: creating TABLE "public.registry" pg_restore: creating TABLE "public.releases" pg_restore: creating VIEW "public.relevant_hints" pg_restore: creating TABLE "public.reproducible" pg_restore: creating TABLE "public.screenshots" pg_restore: creating TABLE "public.security_issues" pg_restore: creating TABLE "public.security_issues_releases" pg_restore: creating TABLE "public.sources_files" pg_restore: creating VIEW "public.sources_patches" pg_restore: creating MATERIALIZED VIEW "public.sources_patches_status" pg_restore: creating VIEW "public.sources_popcon" pg_restore: creating VIEW "public.sources_redundant" pg_restore: creating VIEW "public.sponsorship_requests" pg_restore: creating TABLE "public.testing_autoremovals" pg_restore: creating TABLE "public.timestamps" pg_restore: creating SEQUENCE "public.timestamps_id_seq" pg_restore: creating SEQUENCE OWNED BY "public.timestamps_id_seq" pg_restore: creating TABLE "public.ubuntu_bugs" pg_restore: creating TABLE "public.ubuntu_bugs_duplicates" pg_restore: creating TABLE "public.ubuntu_bugs_subscribers" pg_restore: creating TABLE "public.ubuntu_bugs_tags" pg_restore: creating TABLE "public.ubuntu_bugs_tasks" pg_restore: creating TABLE "public.ubuntu_description_imports" pg_restore: creating TABLE "public.ubuntu_descriptions" pg_restore: creating TABLE "public.ubuntu_packages_summary" pg_restore: creating TABLE "public.ubuntu_popcon" pg_restore: creating TABLE "public.ubuntu_popcon_src" pg_restore: creating TABLE "public.ubuntu_popcon_src_average" pg_restore: creating VIEW "public.ubuntu_sources_popcon" pg_restore: creating TABLE "public.ubuntu_upload_history" pg_restore: creating TABLE "public.ubuntu_upload_history_closes" pg_restore: creating TABLE "public.ubuntu_upload_history_launchpad_closes" pg_restore: creating TABLE "public.ubuntu_uploaders" pg_restore: creating TABLE "public.udd_logs" pg_restore: creating TABLE "public.unofficial_descriptions" pg_restore: creating TABLE "public.unofficial_packages" pg_restore: creating TABLE "public.unofficial_packages_distrelcomparch" pg_restore: creating TABLE "public.unofficial_packages_summary" pg_restore: creating TABLE "public.unofficial_sources" pg_restore: creating TABLE "public.unofficial_uploaders" pg_restore: creating TABLE "public.upload_history_architecture" pg_restore: creating TABLE "public.upload_history_closes" pg_restore: creating TABLE "public.upstream" pg_restore: creating TABLE "public.upstream_metadata" pg_restore: creating TABLE "public.vcs" pg_restore: creating TABLE "public.vcswatch" pg_restore: creating TABLE "public.wannabuild" pg_restore: creating VIEW "public.wnpp" pg_restore: creating DEFAULT "public.timestamps id" pg_restore: processing data for table "history.sources_count" pg_restore: processing data for table "public.archived_bugs" pg_restore: processing data for table "public.archived_bugs_blockedby" pg_restore: processing data for table "public.archived_bugs_blocks" pg_restore: processing data for table "public.archived_bugs_fixed_in" pg_restore: processing data for table "public.archived_bugs_found_in" pg_restore: processing data for table "public.archived_bugs_merged_with" pg_restore: processing data for table "public.archived_bugs_packages" pg_restore: processing data for table "public.archived_bugs_stamps" pg_restore: processing data for table "public.archived_bugs_tags" pg_restore: processing data for table "public.archived_descriptions" pg_restore: processing data for table "public.archived_packages" pg_restore: processing data for table "public.archived_packages_distrelcomparch" pg_restore: processing data for table "public.archived_packages_summary" pg_restore: processing data for table "public.archived_sources" pg_restore: processing data for table "public.archived_uploaders" pg_restore: processing data for table "public.bibref" pg_restore: processing data for table "public.blends_dependencies" pg_restore: processing data for table "public.blends_dependencies_alternatives" pg_restore: processing data for table "public.blends_dependencies_priorities" pg_restore: processing data for table "public.blends_metadata" pg_restore: processing data for table "public.blends_prospectivepackages" pg_restore: processing data for table "public.blends_remarks" pg_restore: processing data for table "public.blends_tasks" pg_restore: processing data for table "public.blends_unknown_packages" pg_restore: processing data for table "public.bts_tags" pg_restore: processing data for table "public.bugs" pg_restore: processing data for table "public.bugs_blockedby" pg_restore: processing data for table "public.bugs_blocks" pg_restore: processing data for table "public.bugs_fixed_in" pg_restore: processing data for table "public.bugs_found_in" pg_restore: processing data for table "public.bugs_merged_with" pg_restore: processing data for table "public.bugs_packages" pg_restore: processing data for table "public.bugs_stamps" pg_restore: processing data for table "public.bugs_tags" pg_restore: processing data for table "public.bugs_usertags" pg_restore: processing data for table "public.carnivore_emails" pg_restore: processing data for table "public.carnivore_keys" pg_restore: processing data for table "public.carnivore_login" pg_restore: processing data for table "public.carnivore_names" pg_restore: processing data for table "public.ci" pg_restore: processing data for table "public.debian_maintainers" pg_restore: processing data for table "public.debtags" pg_restore: processing data for table "public.deferred" pg_restore: processing data for table "public.deferred_architecture" pg_restore: processing data for table "public.deferred_binary" pg_restore: processing data for table "public.deferred_closes" pg_restore: processing data for table "public.dehs" pg_restore: processing data for table "public.derivatives_descriptions" pg_restore: processing data for table "public.derivatives_packages" pg_restore: processing data for table "public.derivatives_packages_distrelcomparch" pg_restore: processing data for table "public.derivatives_packages_summary" pg_restore: processing data for table "public.derivatives_sources" pg_restore: processing data for table "public.derivatives_uploaders" pg_restore: processing data for table "public.description_imports" pg_restore: processing data for table "public.descriptions" pg_restore: processing data for table "public.duck" pg_restore: processing data for table "public.edam" pg_restore: processing data for table "public.ftp_autorejects" pg_restore: processing data for table "public.hints" pg_restore: processing data for table "public.key_packages" pg_restore: processing data for table "public.lintian_logs" pg_restore: processing data for table "public.lintian_results" pg_restore: processing data for table "public.lintian_tags_descriptions" pg_restore: processing data for table "public.mentors_raw_uploads" pg_restore: processing data for table "public.migration_excuses" pg_restore: processing data for table "public.migrations" pg_restore: processing data for table "public.new_packages" pg_restore: processing data for table "public.new_sources" pg_restore: processing data for table "public.orphaned_packages" pg_restore: processing data for table "public.package_removal" pg_restore: processing data for table "public.package_removal_batch" pg_restore: processing data for table "public.packages" pg_restore: processing data for table "public.packages_distrelcomparch" pg_restore: processing data for table "public.packages_summary" pg_restore: processing data for table "public.patches" pg_restore: processing data for table "public.patches_status" pg_restore: processing data for table "public.piuparts_status" pg_restore: processing data for table "public.popcon" pg_restore: processing data for table "public.popcon_src" pg_restore: processing data for table "public.popcon_src_average" pg_restore: processing data for table "public.ports_descriptions" pg_restore: processing data for table "public.ports_packages" pg_restore: processing data for table "public.ports_packages_distrelcomparch" pg_restore: processing data for table "public.ports_packages_summary" pg_restore: processing data for table "public.ports_sources" pg_restore: processing data for table "public.ports_uploaders" pg_restore: processing data for table "public.potential_bug_closures" pg_restore: processing data for table "public.pseudo_packages" pg_restore: processing data for table "public.registry" pg_restore: processing data for table "public.releases" pg_restore: processing data for table "public.reproducible" pg_restore: processing data for table "public.screenshots" pg_restore: processing data for table "public.security_issues" pg_restore: processing data for table "public.security_issues_releases" pg_restore: processing data for table "public.sources" pg_restore: processing data for table "public.sources_files" pg_restore: processing data for table "public.testing_autoremovals" pg_restore: processing data for table "public.timestamps" pg_restore: processing data for table "public.ubuntu_bugs" pg_restore: processing data for table "public.ubuntu_bugs_duplicates" pg_restore: processing data for table "public.ubuntu_bugs_subscribers" pg_restore: processing data for table "public.ubuntu_bugs_tags" pg_restore: processing data for table "public.ubuntu_bugs_tasks" pg_restore: processing data for table "public.ubuntu_description_imports" pg_restore: processing data for table "public.ubuntu_descriptions" pg_restore: processing data for table "public.ubuntu_packages" pg_restore: processing data for table "public.ubuntu_packages_distrelcomparch" pg_restore: processing data for table "public.ubuntu_packages_summary" pg_restore: processing data for table "public.ubuntu_popcon" pg_restore: processing data for table "public.ubuntu_popcon_src" pg_restore: processing data for table "public.ubuntu_popcon_src_average" pg_restore: processing data for table "public.ubuntu_sources" pg_restore: processing data for table "public.ubuntu_upload_history" pg_restore: processing data for table "public.ubuntu_upload_history_closes" pg_restore: processing data for table "public.ubuntu_upload_history_launchpad_closes" pg_restore: processing data for table "public.ubuntu_uploaders" pg_restore: processing data for table "public.udd_logs" pg_restore: processing data for table "public.unofficial_descriptions" pg_restore: processing data for table "public.unofficial_packages" pg_restore: processing data for table "public.unofficial_packages_distrelcomparch" pg_restore: processing data for table "public.unofficial_packages_summary" pg_restore: processing data for table "public.unofficial_sources" pg_restore: processing data for table "public.unofficial_uploaders" pg_restore: processing data for table "public.upload_history" pg_restore: processing data for table "public.upload_history_architecture" pg_restore: processing data for table "public.upload_history_closes" pg_restore: processing data for table "public.uploaders" pg_restore: processing data for table "public.upstream" pg_restore: processing data for table "public.upstream_metadata" pg_restore: processing data for table "public.vcs" pg_restore: processing data for table "public.vcswatch" pg_restore: processing data for table "public.wannabuild" pg_restore: executing SEQUENCE SET timestamps_id_seq pg_restore: creating CONSTRAINT "history.sources_count sources_count_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_blockedby archived_bugs_blockedby_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_blocks archived_bugs_blocks_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_fixed_in archived_bugs_fixed_in_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_found_in archived_bugs_found_in_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_merged_with archived_bugs_merged_with_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_packages archived_bugs_packages_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs archived_bugs_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_stamps archived_bugs_stamps_pkey" pg_restore: creating CONSTRAINT "public.archived_bugs_tags archived_bugs_tags_pkey" pg_restore: creating CONSTRAINT "public.archived_descriptions archived_descriptions_pkey" pg_restore: creating CONSTRAINT "public.archived_packages archived_packages_pkey" pg_restore: creating CONSTRAINT "public.archived_packages_summary archived_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.archived_sources archived_sources_pkey" pg_restore: creating CONSTRAINT "public.bibref bibref_pkey" pg_restore: creating CONSTRAINT "public.blends_dependencies_alternatives blends_dependencies_alternatives_pkey" pg_restore: creating CONSTRAINT "public.blends_dependencies blends_dependencies_pkey" pg_restore: creating CONSTRAINT "public.blends_metadata blends_metadata_pkey" pg_restore: creating CONSTRAINT "public.blends_prospectivepackages blends_prospectivepackages_pkey" pg_restore: creating CONSTRAINT "public.blends_remarks blends_remarks_pkey" pg_restore: creating CONSTRAINT "public.blends_tasks blends_tasks_pkey" pg_restore: creating CONSTRAINT "public.blends_unknown_packages blends_unknown_packages_pkey" pg_restore: creating CONSTRAINT "public.bugs_blockedby bugs_blockedby_pkey" pg_restore: creating CONSTRAINT "public.bugs_blocks bugs_blocks_pkey" pg_restore: creating CONSTRAINT "public.bugs_fixed_in bugs_fixed_in_pkey" pg_restore: creating CONSTRAINT "public.bugs_found_in bugs_found_in_pkey" pg_restore: creating CONSTRAINT "public.bugs_merged_with bugs_merged_with_pkey" pg_restore: creating CONSTRAINT "public.bugs_packages bugs_packages_pkey" pg_restore: creating CONSTRAINT "public.bugs bugs_pkey" pg_restore: creating CONSTRAINT "public.bugs_stamps bugs_stamps_pkey" pg_restore: creating CONSTRAINT "public.bugs_tags bugs_tags_pkey" pg_restore: creating CONSTRAINT "public.carnivore_emails carnivore_emails_pkey" pg_restore: creating CONSTRAINT "public.carnivore_keys carnivore_keys_pkey" pg_restore: creating CONSTRAINT "public.carnivore_login carnivore_login_pkey" pg_restore: creating CONSTRAINT "public.carnivore_names carnivore_names_pkey" pg_restore: creating CONSTRAINT "public.ci ci_pkey" pg_restore: creating CONSTRAINT "public.deferred_architecture deferred_architecture_pkey" pg_restore: creating CONSTRAINT "public.deferred_binary deferred_binary_pkey" pg_restore: creating CONSTRAINT "public.deferred_closes deferred_closes_pkey" pg_restore: creating CONSTRAINT "public.deferred deferred_pkey" pg_restore: creating CONSTRAINT "public.dehs dehs_pkey" pg_restore: creating CONSTRAINT "public.derivatives_descriptions derivatives_descriptions_pkey" pg_restore: creating CONSTRAINT "public.derivatives_packages derivatives_packages_pkey" pg_restore: creating CONSTRAINT "public.derivatives_packages_summary derivatives_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.derivatives_sources derivatives_sources_pkey" pg_restore: creating CONSTRAINT "public.description_imports description_imports_pkey" pg_restore: creating CONSTRAINT "public.descriptions descriptions_pkey" pg_restore: creating CONSTRAINT "public.duck duck_pkey" pg_restore: creating CONSTRAINT "public.edam edam_pkey" pg_restore: creating CONSTRAINT "public.ftp_autorejects ftp_autorejects_pkey" pg_restore: creating CONSTRAINT "public.key_packages key_packages_pkey" pg_restore: creating CONSTRAINT "public.mentors_raw_uploads mentors_raw_uploads_pkey" pg_restore: creating CONSTRAINT "public.migration_excuses migration_excuses_pkey" pg_restore: creating CONSTRAINT "public.migrations migrations_pkey" pg_restore: creating CONSTRAINT "public.new_packages new_packages_pkey" pg_restore: creating CONSTRAINT "public.new_sources new_sources_pkey" pg_restore: creating CONSTRAINT "public.orphaned_packages orphaned_packages_pkey" pg_restore: creating CONSTRAINT "public.package_removal_batch package_removal_batch_pkey" pg_restore: creating CONSTRAINT "public.package_removal package_removal_pkey" pg_restore: creating CONSTRAINT "public.packages packages_pkey" pg_restore: creating CONSTRAINT "public.packages_summary packages_summary_pkey" pg_restore: creating CONSTRAINT "public.popcon popcon_pkey" pg_restore: creating CONSTRAINT "public.popcon_src_average popcon_src_average_pkey" pg_restore: creating CONSTRAINT "public.popcon_src popcon_src_pkey" pg_restore: creating CONSTRAINT "public.ports_descriptions ports_descriptions_pkey" pg_restore: creating CONSTRAINT "public.ports_packages ports_packages_pkey" pg_restore: creating CONSTRAINT "public.ports_packages_summary ports_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.ports_sources ports_sources_pkey" pg_restore: creating CONSTRAINT "public.pseudo_packages pseudo_packages_pkey" pg_restore: creating CONSTRAINT "public.registry registry_pkey" pg_restore: creating CONSTRAINT "public.releases releases_pkey" pg_restore: creating CONSTRAINT "public.reproducible reproducible_pkey" pg_restore: creating CONSTRAINT "public.screenshots screenshots_pkey" pg_restore: creating CONSTRAINT "public.security_issues security_issues_pkey" pg_restore: creating CONSTRAINT "public.security_issues_releases security_issues_releases_pkey" pg_restore: creating CONSTRAINT "public.sources sources_pkey" pg_restore: creating CONSTRAINT "public.timestamps timestamps_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs_duplicates ubuntu_bugs_duplicates_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs ubuntu_bugs_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs_tags ubuntu_bugs_tags_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_bugs_tasks ubuntu_bugs_tasks_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_description_imports ubuntu_description_imports_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_descriptions ubuntu_descriptions_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_packages ubuntu_packages_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_packages_summary ubuntu_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_popcon ubuntu_popcon_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_popcon_src_average ubuntu_popcon_src_average_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_popcon_src ubuntu_popcon_src_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_sources ubuntu_sources_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_upload_history_closes ubuntu_upload_history_closes_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_upload_history_launchpad_closes ubuntu_upload_history_launchpad_closes_pkey" pg_restore: creating CONSTRAINT "public.ubuntu_upload_history ubuntu_upload_history_pkey" pg_restore: creating CONSTRAINT "public.udd_logs udd_logs_pkey" pg_restore: creating CONSTRAINT "public.unofficial_descriptions unofficial_descriptions_pkey" pg_restore: creating CONSTRAINT "public.unofficial_packages unofficial_packages_pkey" pg_restore: creating CONSTRAINT "public.unofficial_packages_summary unofficial_packages_summary_pkey" pg_restore: creating CONSTRAINT "public.unofficial_sources unofficial_sources_pkey" pg_restore: creating CONSTRAINT "public.upload_history_architecture upload_history_architecture_pkey" pg_restore: creating CONSTRAINT "public.upload_history_closes upload_history_closes_pkey" pg_restore: creating CONSTRAINT "public.upload_history upload_history_pkey" pg_restore: creating CONSTRAINT "public.upstream_metadata upstream_metadata_pkey" pg_restore: creating CONSTRAINT "public.upstream upstream_pkey" pg_restore: creating CONSTRAINT "public.vcs vcs_pkey" pg_restore: creating CONSTRAINT "public.vcswatch vcswatch_pkey" pg_restore: creating CONSTRAINT "public.wannabuild wannabuild_pkey" pg_restore: creating INDEX "public.archived_packages_distrelcomp_idx" pg_restore: creating INDEX "public.archived_packages_source_idx" pg_restore: creating INDEX "public.archived_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.archived_sources_distrelcomp_idx" pg_restore: creating INDEX "public.archived_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.bugs_package_idx" pg_restore: creating INDEX "public.bugs_packages_package_idx" pg_restore: creating INDEX "public.bugs_packages_source_idx" pg_restore: creating INDEX "public.bugs_severity_idx" pg_restore: creating INDEX "public.bugs_source_idx" pg_restore: creating INDEX "public.bugs_tags_tag_idx" pg_restore: creating INDEX "public.carnivore_keys_id_idx" pg_restore: creating INDEX "public.debtags_package_idx" pg_restore: creating INDEX "public.debtags_tag_idx" pg_restore: creating INDEX "public.derivatives_packages_distrelcomp_idx" pg_restore: creating INDEX "public.derivatives_packages_source_idx" pg_restore: creating INDEX "public.derivatives_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.derivatives_sources_distrelcomp_idx" pg_restore: creating INDEX "public.derivatives_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.hints_idx" pg_restore: creating INDEX "public.lintian_logs_idx" pg_restore: creating INDEX "public.lintian_results_agg_idx" pg_restore: creating INDEX "public.lintian_results_agg_unique_idx" pg_restore: creating INDEX "public.lintian_results_idx" pg_restore: creating INDEX "public.lintian_results_packages_idx" pg_restore: creating INDEX "public.lintian_unique_idx" pg_restore: creating INDEX "public.packages_distrelcomp_idx" pg_restore: creating INDEX "public.packages_pkgverarchdistrelcomp_idx" pg_restore: creating INDEX "public.packages_pkgverdescr_idx" pg_restore: creating INDEX "public.packages_source_idx" pg_restore: creating INDEX "public.packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.piuparts_status_section_idx" pg_restore: creating INDEX "public.piuparts_status_source_idx" pg_restore: creating INDEX "public.piuparts_status_status_idx" pg_restore: creating INDEX "public.ports_packages_distrelcomp_idx" pg_restore: creating INDEX "public.ports_packages_source_idx" pg_restore: creating INDEX "public.ports_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.ports_sources_distrelcomp_idx" pg_restore: creating INDEX "public.ports_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.potential_bug_closures_id_idx" pg_restore: creating INDEX "public.potential_bug_closures_source_idx" pg_restore: creating INDEX "public.sources_distrelcomp_idx" pg_restore: creating INDEX "public.sources_release_idx" pg_restore: creating INDEX "public.testing_autoremovals_source_idx" pg_restore: creating INDEX "public.ubuntu_bugs_duplicates_idx" pg_restore: creating INDEX "public.ubuntu_bugs_subscribers_idx" pg_restore: creating INDEX "public.ubuntu_bugs_tags_idx" pg_restore: creating INDEX "public.ubuntu_bugs_tasks_idx" pg_restore: creating INDEX "public.ubuntu_bugs_tasks_package_idx" pg_restore: creating INDEX "public.ubuntu_packages_distrelcomp_idx" pg_restore: creating INDEX "public.ubuntu_packages_pkgverdescr_idx" pg_restore: creating INDEX "public.ubuntu_packages_source_idx" pg_restore: creating INDEX "public.ubuntu_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.ubuntu_sources_distrelcomp_idx" pg_restore: creating INDEX "public.ubuntu_sources_release_idx" pg_restore: creating INDEX "public.ubuntu_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.unofficial_packages_distrelcomp_idx" pg_restore: creating INDEX "public.unofficial_packages_source_idx" pg_restore: creating INDEX "public.unofficial_packages_summary_distrelcompsrcver_idx" pg_restore: creating INDEX "public.unofficial_sources_distrelcomp_idx" pg_restore: creating INDEX "public.unofficial_uploaders_distrelcompsrcver_idx" pg_restore: creating INDEX "public.upload_history_distribution_date_idx" pg_restore: creating INDEX "public.upload_history_fingerprint_idx" pg_restore: creating INDEX "public.uploaders_distrelcompsrcver_idx" pg_restore: creating FK CONSTRAINT "public.archived_bugs_blockedby archived_bugs_blockedby_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_blocks archived_bugs_blocks_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_fixed_in archived_bugs_fixed_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_found_in archived_bugs_found_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_merged_with archived_bugs_merged_with_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_packages archived_bugs_packages_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_bugs_tags archived_bugs_tags_id_fkey" pg_restore: creating FK CONSTRAINT "public.archived_packages archived_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.blends_dependencies_alternatives blends_dependencies_alternatives_blend_fkey" pg_restore: creating FK CONSTRAINT "public.blends_dependencies blends_dependencies_blend_fkey" pg_restore: creating FK CONSTRAINT "public.blends_tasks blends_tasks_blend_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_blockedby bugs_blockedby_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_blocks bugs_blocks_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_fixed_in bugs_fixed_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_found_in bugs_found_in_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_merged_with bugs_merged_with_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_packages bugs_packages_id_fkey" pg_restore: creating FK CONSTRAINT "public.bugs_tags bugs_tags_id_fkey" pg_restore: creating FK CONSTRAINT "public.deferred_architecture deferred_architecture_source_fkey" pg_restore: creating FK CONSTRAINT "public.deferred_binary deferred_binary_source_fkey" pg_restore: creating FK CONSTRAINT "public.deferred_closes deferred_closes_source_fkey" pg_restore: creating FK CONSTRAINT "public.derivatives_packages derivatives_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.package_removal package_removal_batch_id_fkey" pg_restore: creating FK CONSTRAINT "public.security_issues_releases security_issues_releases_source_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_duplicates ubuntu_bugs_duplicates_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_subscribers ubuntu_bugs_subscribers_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_tags ubuntu_bugs_tags_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_bugs_tasks ubuntu_bugs_tasks_bug_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_packages ubuntu_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_upload_history_closes ubuntu_upload_history_closes_source_fkey" pg_restore: creating FK CONSTRAINT "public.ubuntu_upload_history_launchpad_closes ubuntu_upload_history_launchpad_closes_source_fkey" pg_restore: creating FK CONSTRAINT "public.unofficial_packages unofficial_packages_package_fkey" pg_restore: creating FK CONSTRAINT "public.upload_history_architecture upload_history_architecture_source_fkey" pg_restore: creating FK CONSTRAINT "public.upload_history_closes upload_history_closes_source_fkey" pg_restore: creating ACL "SCHEMA history" pg_restore: creating ACL "SCHEMA public" pg_restore: creating ACL "public.TYPE bugs_severity" pg_restore: creating ACL "public.TYPE dehs_status" pg_restore: creating ACL "public.TYPE ftp_autoreject_level" pg_restore: creating ACL "public.TYPE ftp_autoreject_type" pg_restore: creating ACL "public.TYPE security_issues_releases_status" pg_restore: creating ACL "public.TYPE security_issues_scope" pg_restore: creating ACL "history.TABLE sources_count" pg_restore: creating ACL "public.TABLE sources" pg_restore: creating ACL "public.TABLE uploaders" pg_restore: creating ACL "public.TABLE carnivore_keys" pg_restore: creating ACL "public.TABLE carnivore_login" pg_restore: creating ACL "public.TABLE active_dds" pg_restore: creating ACL "public.TABLE archived_bugs" pg_restore: creating ACL "public.TABLE bugs" pg_restore: creating ACL "public.TABLE all_bugs" pg_restore: creating ACL "public.TABLE derivatives_packages" pg_restore: creating ACL "public.TABLE packages" pg_restore: creating ACL "public.TABLE ubuntu_packages" pg_restore: creating ACL "public.TABLE all_packages" pg_restore: creating ACL "public.TABLE derivatives_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE packages_distrelcomparch" pg_restore: creating ACL "public.TABLE ubuntu_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE all_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE derivatives_sources" pg_restore: creating ACL "public.TABLE ubuntu_sources" pg_restore: creating ACL "public.TABLE all_sources" pg_restore: creating ACL "public.TABLE archived_bugs_blockedby" pg_restore: creating ACL "public.TABLE archived_bugs_blocks" pg_restore: creating ACL "public.TABLE archived_bugs_fixed_in" pg_restore: creating ACL "public.TABLE archived_bugs_found_in" pg_restore: creating ACL "public.TABLE archived_bugs_merged_with" pg_restore: creating ACL "public.TABLE archived_bugs_packages" pg_restore: creating ACL "public.TABLE archived_bugs_stamps" pg_restore: creating ACL "public.TABLE archived_bugs_tags" pg_restore: creating ACL "public.TABLE archived_descriptions" pg_restore: creating ACL "public.TABLE archived_packages" pg_restore: creating ACL "public.TABLE archived_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE archived_packages_summary" pg_restore: creating ACL "public.TABLE archived_sources" pg_restore: creating ACL "public.TABLE archived_uploaders" pg_restore: creating ACL "public.TABLE bugs_merged_with" pg_restore: creating ACL "public.TABLE bugs_count" pg_restore: creating ACL "public.TABLE migrations" pg_restore: creating ACL "public.TABLE orphaned_packages" pg_restore: creating ACL "public.TABLE popcon_src" pg_restore: creating ACL "public.TABLE sources_uniq" pg_restore: creating ACL "public.TABLE upload_history" pg_restore: creating ACL "public.TABLE upload_history_nmus" pg_restore: creating ACL "public.TABLE bapase" pg_restore: creating ACL "public.TABLE bibref" pg_restore: creating ACL "public.TABLE blends_dependencies" pg_restore: creating ACL "public.TABLE blends_dependencies_alternatives" pg_restore: creating ACL "public.TABLE blends_dependencies_priorities" pg_restore: creating ACL "public.TABLE blends_metadata" pg_restore: creating ACL "public.TABLE blends_prospectivepackages" pg_restore: creating ACL "public.TABLE blends_remarks" pg_restore: creating ACL "public.TABLE blends_tasks" pg_restore: creating ACL "public.TABLE blends_unknown_packages" pg_restore: creating ACL "public.TABLE bts_tags" pg_restore: creating ACL "public.TABLE bugs_blockedby" pg_restore: creating ACL "public.TABLE bugs_blocks" pg_restore: creating ACL "public.TABLE bugs_fixed_in" pg_restore: creating ACL "public.TABLE bugs_found_in" pg_restore: creating ACL "public.TABLE bugs_packages" pg_restore: creating ACL "public.TABLE bugs_rt_affects_oldstable" pg_restore: creating ACL "public.TABLE bugs_rt_affects_stable" pg_restore: creating ACL "public.TABLE bugs_rt_affects_testing" pg_restore: creating ACL "public.TABLE bugs_rt_affects_unstable" pg_restore: creating ACL "public.TABLE bugs_rt_affects_testing_and_unstable" pg_restore: creating ACL "public.TABLE bugs_stamps" pg_restore: creating ACL "public.TABLE bugs_tags" pg_restore: creating ACL "public.TABLE bugs_usertags" pg_restore: creating ACL "public.TABLE carnivore_emails" pg_restore: creating ACL "public.TABLE carnivore_names" pg_restore: creating ACL "public.TABLE ci" pg_restore: creating ACL "public.TABLE debian_maintainers" pg_restore: creating ACL "public.TABLE debtags" pg_restore: creating ACL "public.TABLE deferred" pg_restore: creating ACL "public.TABLE deferred_architecture" pg_restore: creating ACL "public.TABLE deferred_binary" pg_restore: creating ACL "public.TABLE deferred_closes" pg_restore: creating ACL "public.TABLE dehs" pg_restore: creating ACL "public.TABLE derivatives_descriptions" pg_restore: creating ACL "public.TABLE derivatives_packages_summary" pg_restore: creating ACL "public.TABLE derivatives_uploaders" pg_restore: creating ACL "public.TABLE description_imports" pg_restore: creating ACL "public.TABLE descriptions" pg_restore: creating ACL "public.TABLE duck" pg_restore: creating ACL "public.TABLE edam" pg_restore: creating ACL "public.TABLE ftp_autorejects" pg_restore: creating ACL "public.TABLE hints" pg_restore: creating ACL "public.TABLE key_packages" pg_restore: creating ACL "public.TABLE lintian_results" pg_restore: creating ACL "public.TABLE lintian_results_agg" pg_restore: creating ACL "public.TABLE lintian" pg_restore: creating ACL "public.TABLE lintian_logs" pg_restore: creating ACL "public.TABLE lintian_tags_descriptions" pg_restore: creating ACL "public.TABLE mentors_raw_uploads" pg_restore: creating ACL "public.TABLE mentors_most_recent_package_versions" pg_restore: creating ACL "public.TABLE migration_excuses" pg_restore: creating ACL "public.TABLE new_packages" pg_restore: creating ACL "public.TABLE new_packages_madison" pg_restore: creating ACL "public.TABLE new_sources" pg_restore: creating ACL "public.TABLE new_sources_madison" pg_restore: creating ACL "public.TABLE package_removal" pg_restore: creating ACL "public.TABLE package_removal_batch" pg_restore: creating ACL "public.TABLE packages_summary" pg_restore: creating ACL "public.TABLE patches" pg_restore: creating ACL "public.TABLE patches_status" pg_restore: creating ACL "public.TABLE piuparts_status" pg_restore: creating ACL "public.TABLE popcon" pg_restore: creating ACL "public.TABLE popcon_src_average" pg_restore: creating ACL "public.TABLE ports_descriptions" pg_restore: creating ACL "public.TABLE ports_packages" pg_restore: creating ACL "public.TABLE ports_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE ports_packages_summary" pg_restore: creating ACL "public.TABLE ports_sources" pg_restore: creating ACL "public.TABLE ports_uploaders" pg_restore: creating ACL "public.TABLE potential_bug_closures" pg_restore: creating ACL "public.TABLE pseudo_packages" pg_restore: creating ACL "public.TABLE registry" pg_restore: creating ACL "public.TABLE releases" pg_restore: creating ACL "public.TABLE relevant_hints" pg_restore: creating ACL "public.TABLE reproducible" pg_restore: creating ACL "public.TABLE screenshots" pg_restore: creating ACL "public.TABLE security_issues" pg_restore: creating ACL "public.TABLE security_issues_releases" pg_restore: creating ACL "public.TABLE sources_files" pg_restore: creating ACL "public.TABLE sources_patches" pg_restore: creating ACL "public.TABLE sources_patches_status" pg_restore: creating ACL "public.TABLE sources_popcon" pg_restore: creating ACL "public.TABLE sources_redundant" pg_restore: creating ACL "public.TABLE sponsorship_requests" pg_restore: creating ACL "public.TABLE testing_autoremovals" pg_restore: creating ACL "public.TABLE timestamps" pg_restore: creating ACL "public.SEQUENCE timestamps_id_seq" pg_restore: creating ACL "public.TABLE ubuntu_bugs" pg_restore: creating ACL "public.TABLE ubuntu_bugs_duplicates" pg_restore: creating ACL "public.TABLE ubuntu_bugs_subscribers" pg_restore: creating ACL "public.TABLE ubuntu_bugs_tags" pg_restore: creating ACL "public.TABLE ubuntu_bugs_tasks" pg_restore: creating ACL "public.TABLE ubuntu_description_imports" pg_restore: creating ACL "public.TABLE ubuntu_descriptions" pg_restore: creating ACL "public.TABLE ubuntu_packages_summary" pg_restore: creating ACL "public.TABLE ubuntu_popcon" pg_restore: creating ACL "public.TABLE ubuntu_popcon_src" pg_restore: creating ACL "public.TABLE ubuntu_popcon_src_average" pg_restore: creating ACL "public.TABLE ubuntu_sources_popcon" pg_restore: creating ACL "public.TABLE ubuntu_upload_history" pg_restore: creating ACL "public.TABLE ubuntu_upload_history_closes" pg_restore: creating ACL "public.TABLE ubuntu_upload_history_launchpad_closes" pg_restore: creating ACL "public.TABLE ubuntu_uploaders" pg_restore: creating ACL "public.TABLE udd_logs" pg_restore: creating ACL "public.TABLE unofficial_descriptions" pg_restore: creating ACL "public.TABLE unofficial_packages" pg_restore: creating ACL "public.TABLE unofficial_packages_distrelcomparch" pg_restore: creating ACL "public.TABLE unofficial_packages_summary" pg_restore: creating ACL "public.TABLE unofficial_sources" pg_restore: creating ACL "public.TABLE unofficial_uploaders" pg_restore: creating ACL "public.TABLE upload_history_architecture" pg_restore: creating ACL "public.TABLE upload_history_closes" pg_restore: creating ACL "public.TABLE upstream" pg_restore: creating ACL "public.TABLE upstream_metadata" pg_restore: creating ACL "public.TABLE vcs" pg_restore: creating ACL "public.TABLE vcswatch" pg_restore: creating ACL "public.TABLE wannabuild" pg_restore: creating ACL "public.TABLE wnpp" pg_restore: creating MATERIALIZED VIEW DATA "public.lintian_results_agg" pg_restore: creating MATERIALIZED VIEW DATA "public.lintian" pg_restore: creating MATERIALIZED VIEW DATA "public.sources_patches_status" REVOKE CONNECT ON DATABASE udd_20240328_551437 FROM public REVOKE SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd_20240328_551437' pg_terminate_backend ---------------------- (0 rows) Created udd_20240328_551437. REVOKE CONNECT ON DATABASE udd FROM public REVOKE SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd' pg_terminate_backend ---------------------- t t t (3 rows) SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd' pg_terminate_backend ---------------------- (0 rows) SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd_20240328_551437' pg_terminate_backend ---------------------- (0 rows) ALTER DATABASE "udd_20240328_551437" RENAME TO udd ALTER DATABASE GRANT CONNECT ON DATABASE udd TO public GRANT GRANT select ON ALL TABLES IN SCHEMA public TO "public-udd-mirror"; GRANT GRANT select ON ALL TABLES IN SCHEMA public TO "udd-mirror"; GRANT Thu Mar 28 16:05:06 UTC 2024: UDD mirror successfully updated! Releasing lock. removed '/tmp/update_udd.udd-mirror.lock'