New warnings from the PG flexible server database dump #1422

daveverwer · 2021-12-06T16:30:38Z

daveverwer
Dec 6, 2021
Maintainer

This is nothing to worry about, but for reference, there are new warnings when importing a database dump from the new Azure Flexible PG server. Presumably, some system-defined roles there get privileges on some of the internal PG tables and entities.

$ ./scripts/load-db.sh spi_prod-2021-12-06.dump
spi_dev
05c66fa5689cdb3e938024421291ad1c9e1f5d8bd8fd42fec9a1ebe5e29eaa60
Giving Postgres a moment to launch ...
Importing
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 3753; 0 0 ACL SCHEMA public azure_pg_admin
pg_restore: error: could not execute query: ERROR:  role "azuresu" does not exist
Command was: REVOKE ALL ON SCHEMA public FROM azuresu;
REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO azure_pg_admin;
GRANT ALL ON SCHEMA public TO PUBLIC;


pg_restore: from TOC entry 3755; 0 0 ACL FUNCTION pg_replication_origin_advance(text, pg_lsn) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_replication_origin_advance(text, pg_lsn) TO azure_pg_admin;


pg_restore: from TOC entry 3756; 0 0 ACL FUNCTION pg_replication_origin_create(text) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_replication_origin_create(text) TO azure_pg_admin;


pg_restore: from TOC entry 3757; 0 0 ACL FUNCTION pg_replication_origin_drop(text) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_replication_origin_drop(text) TO azure_pg_admin;


pg_restore: from TOC entry 3758; 0 0 ACL FUNCTION pg_replication_origin_oid(text) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_replication_origin_oid(text) TO azure_pg_admin;


pg_restore: from TOC entry 3759; 0 0 ACL FUNCTION pg_replication_origin_progress(text, boolean) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_replication_origin_progress(text, boolean) TO azure_pg_admin;


pg_restore: from TOC entry 3760; 0 0 ACL FUNCTION pg_replication_origin_session_is_setup() azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_replication_origin_session_is_setup() TO azure_pg_admin;


pg_restore: from TOC entry 3761; 0 0 ACL FUNCTION pg_replication_origin_session_progress(boolean) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_replication_origin_session_progress(boolean) TO azure_pg_admin;


pg_restore: from TOC entry 3762; 0 0 ACL FUNCTION pg_replication_origin_session_reset() azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_replication_origin_session_reset() TO azure_pg_admin;


pg_restore: from TOC entry 3763; 0 0 ACL FUNCTION pg_replication_origin_session_setup(text) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_replication_origin_session_setup(text) TO azure_pg_admin;


pg_restore: from TOC entry 3764; 0 0 ACL FUNCTION pg_replication_origin_xact_reset() azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_replication_origin_xact_reset() TO azure_pg_admin;


pg_restore: from TOC entry 3765; 0 0 ACL FUNCTION pg_replication_origin_xact_setup(pg_lsn, timestamp with time zone) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_replication_origin_xact_setup(pg_lsn, timestamp with time zone) TO azure_pg_admin;


pg_restore: from TOC entry 3766; 0 0 ACL FUNCTION pg_show_replication_origin_status(OUT local_id oid, OUT external_id text, OUT remote_lsn pg_lsn, OUT local_lsn pg_lsn) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_show_replication_origin_status(OUT local_id oid, OUT external_id text, OUT remote_lsn pg_lsn, OUT local_lsn pg_lsn) TO azure_pg_admin;


pg_restore: from TOC entry 3767; 0 0 ACL FUNCTION pg_stat_reset() azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_stat_reset() TO azure_pg_admin;


pg_restore: from TOC entry 3768; 0 0 ACL FUNCTION pg_stat_reset_shared(text) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_stat_reset_shared(text) TO azure_pg_admin;


pg_restore: from TOC entry 3769; 0 0 ACL FUNCTION pg_stat_reset_single_function_counters(oid) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_stat_reset_single_function_counters(oid) TO azure_pg_admin;


pg_restore: from TOC entry 3770; 0 0 ACL FUNCTION pg_stat_reset_single_table_counters(oid) azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT ALL ON FUNCTION pg_catalog.pg_stat_reset_single_table_counters(oid) TO azure_pg_admin;


pg_restore: from TOC entry 3771; 0 0 ACL COLUMN pg_config.name azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(name) ON TABLE pg_catalog.pg_config TO azure_pg_admin;


pg_restore: from TOC entry 3772; 0 0 ACL COLUMN pg_config.setting azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(setting) ON TABLE pg_catalog.pg_config TO azure_pg_admin;


pg_restore: from TOC entry 3773; 0 0 ACL COLUMN pg_hba_file_rules.line_number azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(line_number) ON TABLE pg_catalog.pg_hba_file_rules TO azure_pg_admin;


pg_restore: from TOC entry 3774; 0 0 ACL COLUMN pg_hba_file_rules.type azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(type) ON TABLE pg_catalog.pg_hba_file_rules TO azure_pg_admin;


pg_restore: from TOC entry 3775; 0 0 ACL COLUMN pg_hba_file_rules.database azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(database) ON TABLE pg_catalog.pg_hba_file_rules TO azure_pg_admin;


pg_restore: from TOC entry 3776; 0 0 ACL COLUMN pg_hba_file_rules.user_name azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(user_name) ON TABLE pg_catalog.pg_hba_file_rules TO azure_pg_admin;


pg_restore: from TOC entry 3777; 0 0 ACL COLUMN pg_hba_file_rules.address azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(address) ON TABLE pg_catalog.pg_hba_file_rules TO azure_pg_admin;


pg_restore: from TOC entry 3778; 0 0 ACL COLUMN pg_hba_file_rules.netmask azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(netmask) ON TABLE pg_catalog.pg_hba_file_rules TO azure_pg_admin;


pg_restore: from TOC entry 3779; 0 0 ACL COLUMN pg_hba_file_rules.auth_method azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(auth_method) ON TABLE pg_catalog.pg_hba_file_rules TO azure_pg_admin;


pg_restore: from TOC entry 3780; 0 0 ACL COLUMN pg_hba_file_rules.options azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(options) ON TABLE pg_catalog.pg_hba_file_rules TO azure_pg_admin;


pg_restore: from TOC entry 3781; 0 0 ACL COLUMN pg_hba_file_rules.error azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(error) ON TABLE pg_catalog.pg_hba_file_rules TO azure_pg_admin;


pg_restore: from TOC entry 3782; 0 0 ACL COLUMN pg_replication_origin_status.local_id azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(local_id) ON TABLE pg_catalog.pg_replication_origin_status TO azure_pg_admin;


pg_restore: from TOC entry 3783; 0 0 ACL COLUMN pg_replication_origin_status.external_id azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(external_id) ON TABLE pg_catalog.pg_replication_origin_status TO azure_pg_admin;


pg_restore: from TOC entry 3784; 0 0 ACL COLUMN pg_replication_origin_status.remote_lsn azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(remote_lsn) ON TABLE pg_catalog.pg_replication_origin_status TO azure_pg_admin;


pg_restore: from TOC entry 3785; 0 0 ACL COLUMN pg_replication_origin_status.local_lsn azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(local_lsn) ON TABLE pg_catalog.pg_replication_origin_status TO azure_pg_admin;


pg_restore: from TOC entry 3786; 0 0 ACL COLUMN pg_shmem_allocations.name azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(name) ON TABLE pg_catalog.pg_shmem_allocations TO azure_pg_admin;


pg_restore: from TOC entry 3787; 0 0 ACL COLUMN pg_shmem_allocations.off azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(off) ON TABLE pg_catalog.pg_shmem_allocations TO azure_pg_admin;


pg_restore: from TOC entry 3788; 0 0 ACL COLUMN pg_shmem_allocations.size azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(size) ON TABLE pg_catalog.pg_shmem_allocations TO azure_pg_admin;


pg_restore: from TOC entry 3789; 0 0 ACL COLUMN pg_shmem_allocations.allocated_size azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(allocated_size) ON TABLE pg_catalog.pg_shmem_allocations TO azure_pg_admin;


pg_restore: from TOC entry 3790; 0 0 ACL COLUMN pg_statistic.starelid azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(starelid) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3791; 0 0 ACL COLUMN pg_statistic.staattnum azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(staattnum) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3792; 0 0 ACL COLUMN pg_statistic.stainherit azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stainherit) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3793; 0 0 ACL COLUMN pg_statistic.stanullfrac azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stanullfrac) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3794; 0 0 ACL COLUMN pg_statistic.stawidth azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stawidth) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3795; 0 0 ACL COLUMN pg_statistic.stadistinct azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stadistinct) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3796; 0 0 ACL COLUMN pg_statistic.stakind1 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stakind1) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3797; 0 0 ACL COLUMN pg_statistic.stakind2 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stakind2) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3798; 0 0 ACL COLUMN pg_statistic.stakind3 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stakind3) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3799; 0 0 ACL COLUMN pg_statistic.stakind4 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stakind4) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3800; 0 0 ACL COLUMN pg_statistic.stakind5 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stakind5) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3801; 0 0 ACL COLUMN pg_statistic.staop1 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(staop1) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3802; 0 0 ACL COLUMN pg_statistic.staop2 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(staop2) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3803; 0 0 ACL COLUMN pg_statistic.staop3 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(staop3) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3804; 0 0 ACL COLUMN pg_statistic.staop4 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(staop4) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3805; 0 0 ACL COLUMN pg_statistic.staop5 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(staop5) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3806; 0 0 ACL COLUMN pg_statistic.stacoll1 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stacoll1) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3807; 0 0 ACL COLUMN pg_statistic.stacoll2 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stacoll2) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3808; 0 0 ACL COLUMN pg_statistic.stacoll3 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stacoll3) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3809; 0 0 ACL COLUMN pg_statistic.stacoll4 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stacoll4) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3810; 0 0 ACL COLUMN pg_statistic.stacoll5 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stacoll5) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3811; 0 0 ACL COLUMN pg_statistic.stanumbers1 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stanumbers1) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3812; 0 0 ACL COLUMN pg_statistic.stanumbers2 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stanumbers2) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3813; 0 0 ACL COLUMN pg_statistic.stanumbers3 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stanumbers3) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3814; 0 0 ACL COLUMN pg_statistic.stanumbers4 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stanumbers4) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3815; 0 0 ACL COLUMN pg_statistic.stanumbers5 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stanumbers5) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3816; 0 0 ACL COLUMN pg_statistic.stavalues1 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stavalues1) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3817; 0 0 ACL COLUMN pg_statistic.stavalues2 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stavalues2) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3818; 0 0 ACL COLUMN pg_statistic.stavalues3 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stavalues3) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3819; 0 0 ACL COLUMN pg_statistic.stavalues4 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stavalues4) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3820; 0 0 ACL COLUMN pg_statistic.stavalues5 azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(stavalues5) ON TABLE pg_catalog.pg_statistic TO azure_pg_admin;


pg_restore: from TOC entry 3821; 0 0 ACL COLUMN pg_subscription.oid azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(oid) ON TABLE pg_catalog.pg_subscription TO azure_pg_admin;


pg_restore: from TOC entry 3822; 0 0 ACL COLUMN pg_subscription.subdbid azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(subdbid) ON TABLE pg_catalog.pg_subscription TO azure_pg_admin;


pg_restore: from TOC entry 3823; 0 0 ACL COLUMN pg_subscription.subname azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(subname) ON TABLE pg_catalog.pg_subscription TO azure_pg_admin;


pg_restore: from TOC entry 3824; 0 0 ACL COLUMN pg_subscription.subowner azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(subowner) ON TABLE pg_catalog.pg_subscription TO azure_pg_admin;


pg_restore: from TOC entry 3825; 0 0 ACL COLUMN pg_subscription.subenabled azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(subenabled) ON TABLE pg_catalog.pg_subscription TO azure_pg_admin;


pg_restore: from TOC entry 3826; 0 0 ACL COLUMN pg_subscription.subconninfo azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(subconninfo) ON TABLE pg_catalog.pg_subscription TO azure_pg_admin;


pg_restore: from TOC entry 3827; 0 0 ACL COLUMN pg_subscription.subslotname azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(subslotname) ON TABLE pg_catalog.pg_subscription TO azure_pg_admin;


pg_restore: from TOC entry 3828; 0 0 ACL COLUMN pg_subscription.subsynccommit azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(subsynccommit) ON TABLE pg_catalog.pg_subscription TO azure_pg_admin;


pg_restore: from TOC entry 3829; 0 0 ACL COLUMN pg_subscription.subpublications azuresu
pg_restore: error: could not execute query: ERROR:  role "azure_pg_admin" does not exist
Command was: GRANT SELECT(subpublications) ON TABLE pg_catalog.pg_subscription TO azure_pg_admin;


pg_restore: warning: errors ignored on restore: 76

daveverwer · 2021-12-08T15:14:50Z

daveverwer
Dec 8, 2021
Maintainer Author

Fixed in #1434

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

New warnings from the PG flexible server database dump #1422

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 1 comment

{{title}}

Select a reply

New warnings from the PG flexible server database dump #1422

daveverwer Dec 6, 2021 Maintainer

Replies: 1 comment

daveverwer Dec 8, 2021 Maintainer Author

daveverwer
Dec 6, 2021
Maintainer

daveverwer
Dec 8, 2021
Maintainer Author