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"]
"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],
"relation_members" => [:select, :insert],
"relation_tags" => [:select, :insert],
"relations" => [:select, :insert],
+ "reports" => [:select],
"user_blocks" => [:select],
"user_roles" => [:select],
"users" => [:select],
reports
schema_migrations
user_blocks
+ user_mutes
user_preferences
user_roles
- user_tokens
users
way_nodes
way_tags
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
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