首页 > 解决方案 > 如何在厨师自动化服务器中配置外部 postgresql 数据库

问题描述

我想知道我们如何配置厨师自动化服务器以使用外部 postgresql 数据库。我有一台配置了外部 elasticsearch 和 postgresql 数据库的厨师服务器,现在我想在厨师自动化服务器中使用相同的 postgresql 数据库。有人可以告诉我如何实现这一目标吗?

这是我的 delivery.rb 文件配置

 delivery_fqdn "192.168.0.101"
 delivery['chef_username'] = "delivery"
 delivery['chef_private_key'] = "/etc/delivery/delivery.pem"
 delivery['chef_server'] = "https://192.168.0.102/organizations/automate_org"
 insights['enable'] = true
 elasticsearch['urls'] = ['http://192.168.0.103:9200']
 elasticsearch['external'] = true
 data_collector['token'] = 'helloworld123'
 postgresql['version'] = '9.6'
 postgresql['external'] = true
 postgresql['vip'] = '192.168.0.103'
 postgresql['port'] = '5432'
 postgresql['username'] = 'admin'
 postgresql['superuser_username'] = 'admin'
 postgresql['superuser_password'] = 'admin123'

这是我的 chef-server.rb

postgresql['external'] = true
postgresql['vip'] = '192.168.0.103'
postgresql['port'] = 5432
postgresql['db_superuser'] = 'admin'
postgresql['db_superuser_password'] = 'admin123'
opscode_erchef['search_provider'] = 'elasticsearch'
opscode_solr4['external'] = true
opscode_solr4['external_url'] = 'http://192.168.0.103:9200'
opscode_solr4['elasticsearch_shard_count'] = 3
opscode_solr4['elasticsearch_replica_count'] = 2
opscode_erchef['search_queue_mode'] = 'batch'
rabbitmq['enable'] = false
rabbitmq['management_enabled'] = false
rabbitmq['queue_length_monitor_enabled'] = false
opscode_expander['enable'] = false
dark_launch['actions'] = false
data_collector['root_url'] = 'https://192.168.0.101/data-collector/v0'
profiles['root_url'] = 'https://192.168.0.101'

标签: postgresqlconfigurationchef-infra

解决方案


Chef Automate 服务器仍使用 Chef Server,请参阅此处的自动化设置delivery.rb用于非默认的自动设置。Chef Server 设置可能仍需要设置chef-server.rb请参阅此处,然后运行,chef-server-ctl reconfigure因为 Automate 仍将食谱和数据存储在 Chef Server 中。


推荐阅读