=============================================================================


Log started at Sun Aug 14 00:05:01 UTC 2022
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 Sun Aug 14 02:05:01 UTC 2022
lock taken at /tmp/update_udd.udd-mirror.lock
Downloading udd.dump
2022-08-14 02:06:29 URL:https://udd.debian.org/dumps/udd.dump [1661059885/1661059885] -> "udd.dump" [1]
ERROR:  role "udd" already exists
ERROR:  role "udd-mirror" already exists
ERROR:  role "public-udd-mirror" already exists
ALTER DEFAULT PRIVILEGES
ALTER DEFAULT PRIVILEGES
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.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.piuparts_status"
pg_restore: creating TABLE "public.popcon"
pg_restore: creating TABLE "public.popcon_src_average"
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 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.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.upstream_status"
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.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.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.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.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.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.upstream_status"
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.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.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.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_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_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.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 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 piuparts_status"
pg_restore: creating ACL "public.TABLE popcon"
pg_restore: creating ACL "public.TABLE popcon_src_average"
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_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 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 upstream_status"
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"
REVOKE CONNECT ON DATABASE udd_20220814_108544 FROM public
REVOKE
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'udd_20220814_108544'
 pg_terminate_backend 
----------------------
(0 rows)


Created udd_20220814_108544.
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_20220814_108544'
 pg_terminate_backend 
----------------------
(0 rows)

ALTER DATABASE "udd_20220814_108544" 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

Sun Aug 14 02:19:39 UTC 2022: UDD mirror successfully updated!
Releasing lock.
removed '/tmp/update_udd.udd-mirror.lock'