X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/f4706c8a1efe2449a641f7c362447b2fa6475af1..3e9826e33150fe90d73676118a643b642d7736cc:/cookbooks/db/recipes/master.rb?ds=sidebyside diff --git a/cookbooks/db/recipes/master.rb b/cookbooks/db/recipes/master.rb index 5d2c096ad..606e902bf 100644 --- a/cookbooks/db/recipes/master.rb +++ b/cookbooks/db/recipes/master.rb @@ -62,11 +62,6 @@ postgresql_user "backup" do password passwords["backup"] end -postgresql_user "munin" do - cluster node[:db][:cluster] - password passwords["munin"] -end - postgresql_user "replication" do cluster node[:db][:cluster] password passwords["replication"] @@ -88,7 +83,6 @@ CGIMAP_PERMISSIONS = { "changeset_comments" => [:select], "changeset_tags" => [:select], "changesets" => [:select, :update], - "client_applications" => [:select], "current_node_tags" => [:select, :insert, :delete], "current_nodes" => [:select, :insert, :update], "current_nodes_id_seq" => [:update], @@ -100,17 +94,16 @@ CGIMAP_PERMISSIONS = { "current_way_tags" => [:select, :insert, :delete], "current_ways" => [:select, :insert, :update], "current_ways_id_seq" => [:update], + "issues" => [:select], "node_tags" => [:select, :insert], "nodes" => [:select, :insert], "oauth_access_grants" => [:select], "oauth_access_tokens" => [:select], "oauth_applications" => [:select], - "oauth_nonces" => [:select, :insert], - "oauth_nonces_id_seq" => [:update], - "oauth_tokens" => [:select], "relation_members" => [:select, :insert], "relation_tags" => [:select, :insert], "relations" => [:select, :insert], + "reports" => [:select], "user_blocks" => [:select], "user_roles" => [:select], "users" => [:select], @@ -154,7 +147,6 @@ PROMETHEUS_PERMISSIONS = { changeset_tags changesets changesets_subscribers - client_applications current_node_tags current_nodes current_relation_members @@ -182,9 +174,7 @@ PROMETHEUS_PERMISSIONS = { oauth_access_grants oauth_access_tokens oauth_applications - oauth_nonces oauth_openid_requests - oauth_tokens redactions relation_members relation_tags @@ -192,9 +182,9 @@ PROMETHEUS_PERMISSIONS = { reports schema_migrations user_blocks + user_mutes user_preferences user_roles - user_tokens users way_nodes way_tags @@ -221,7 +211,6 @@ end active_storage_variant_records_id_seq changeset_comments_id_seq changesets_id_seq - client_applications_id_seq current_nodes_id_seq current_relations_id_seq current_ways_id_seq @@ -239,14 +228,12 @@ end oauth_access_grants_id_seq oauth_access_tokens_id_seq oauth_applications_id_seq - oauth_nonces_id_seq oauth_openid_requests_id_seq - oauth_tokens_id_seq redactions_id_seq reports_id_seq user_blocks_id_seq + user_mutes_id_seq user_roles_id_seq - user_tokens_id_seq users_id_seq ].each do |sequence| postgresql_sequence sequence do @@ -301,7 +288,7 @@ end systemd_timer "yearly-reindex" do description "Yearly database reindex" - on_calendar "Fri *-1-8..14 02:00" + on_calendar "Thu *-1-8..14 02:00" end service "yearly-reindex.timer" do