From a20822e47200fde5d2d69b14f44c72843f332666 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Sun, 6 Sep 2026 12:01:06 +0100 Subject: [PATCH] Make osm-logical an allowed output plugin --- cookbooks/postgresql/attributes/default.rb | 1 + cookbooks/postgresql/templates/default/postgresql.conf.erb | 4 ++++ roles/db.rb | 3 +++ 3 files changed, 8 insertions(+) diff --git a/cookbooks/postgresql/attributes/default.rb b/cookbooks/postgresql/attributes/default.rb index 532998eea..6e5868bac 100644 --- a/cookbooks/postgresql/attributes/default.rb +++ b/cookbooks/postgresql/attributes/default.rb @@ -46,6 +46,7 @@ default[:postgresql][:settings][:defaults][:autovacuum_analyze_scale_factor] = " default[:postgresql][:settings][:defaults][:autovacuum_freeze_max_age] = "200000000" default[:postgresql][:settings][:defaults][:autovacuum_multixact_freeze_max_age] = "400000000" default[:postgresql][:settings][:defaults][:shared_preload_libraries] = [] +default[:postgresql][:settings][:defaults][:output_plugin_libraries] = [] default[:postgresql][:settings][:defaults][:max_locks_per_transaction] = "64" default[:postgresql][:settings][:defaults][:user_name_maps] = {} default[:postgresql][:settings][:defaults][:early_authentication_rules] = [] diff --git a/cookbooks/postgresql/templates/default/postgresql.conf.erb b/cookbooks/postgresql/templates/default/postgresql.conf.erb index b43afa783..27ae5603e 100644 --- a/cookbooks/postgresql/templates/default/postgresql.conf.erb +++ b/cookbooks/postgresql/templates/default/postgresql.conf.erb @@ -167,6 +167,10 @@ default_text_search_config = 'pg_catalog.english' shared_preload_libraries = '<%= (@settings[:shared_preload_libraries] || @defaults[:shared_preload_libraries]).sort.join(",") %>' +# - Other Defaults - + +output_plugin_libraries = '<%= (@settings[:output_plugin_libraries] || @defaults[:output_plugin_libraries]).sort.join(",") %>' + #------------------------------------------------------------------------------ # LOCK MANAGEMENT #------------------------------------------------------------------------------ diff --git a/roles/db.rb b/roles/db.rb index d72c4004e..f4f24e1ae 100644 --- a/roles/db.rb +++ b/roles/db.rb @@ -19,6 +19,9 @@ default_attributes( :cpu_tuple_cost => "0.1", :jit => "off", :log_min_duration_statement => "1000", + :output_plugin_libraries => [ + "osm-logical" + ], :late_authentication_rules => [ { :address => "10.0.48.0/20" }, # amsterdam { :address => "10.0.64.0/20" }, # dublin -- 2.47.3