Setting more than one listen_address in postgres crashes sidekiq
I'm trying to make postgres to also listen to the public server IP.
In gitlab.rb
I have:
postgresql['listen_address'] = "127.0.0.1,1.2.3.4"
postgresql['trust_auth_cidr_addresses'] = ['127.0.0.1/32','1.2.3.4/32']
When I remove either IP the error is gone. The interesting part is in sidekiq's log:
2016-03-10_21:02:39.50210 could not translate host name "127.0.0.1,104.236.191.64" to address: Name or service not known
Snippet:
2016-03-10_21:02:29.36265 /opt/gitlab/embedded/service/gitlab-rails/config/environment.rb:5:in `<top (required)>'
2016-03-10_21:02:29.36265 /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activesupport-4.2.5.2/lib/active_support/dependencies.rb:274:in `require'
2016-03-10_21:02:29.36266 /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activesupport-4.2.5.2/lib/active_support/dependencies.rb:274:in `block in require'
2016-03-10_21:02:29.36266 /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activesupport-4.2.5.2/lib/active_support/dependencies.rb:240:in `load_dependency'
2016-03-10_21:02:29.36267 /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activesupport-4.2.5.2/lib/active_support/dependencies.rb:274:in `require'
2016-03-10_21:02:29.36268 /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/sidekiq-4.0.1/lib/sidekiq/cli.rb:236:in `boot_system'
2016-03-10_21:02:29.36268 /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/sidekiq-4.0.1/lib/sidekiq/cli.rb:49:in `run'
2016-03-10_21:02:29.36268 /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/sidekiq-4.0.1/bin/sidekiq:13:in `<top (required)>'
2016-03-10_21:02:29.36268 /opt/gitlab/embedded/service/gem/ruby/2.1.0/bin/sidekiq:23:in `load'
2016-03-10_21:02:29.36269 /opt/gitlab/embedded/service/gem/ruby/2.1.0/bin/sidekiq:23:in `<main>'
2016-03-10_21:02:39.46255 2016-03-10T21:02:39.462Z 2555 TID-473tw INFO: Booting Sidekiq 4.0.1 with redis options {:url=>"unix:/var/opt/gitlab/redis/redis.socket", :namesp
ace=>"resque:gitlab"}
2016-03-10_21:02:39.47393 2016-03-10T21:02:39.473Z 2555 TID-473tw INFO: Cron Jobs - add job with name: stuck_ci_builds_worker
2016-03-10_21:02:39.47677 2016-03-10T21:02:39.476Z 2555 TID-473tw INFO: Cron Jobs - add job with name: historical_data_worker
2016-03-10_21:02:39.47935 2016-03-10T21:02:39.479Z 2555 TID-473tw INFO: Cron Jobs - add job with name: update_all_mirrors_worker
2016-03-10_21:02:39.48230 2016-03-10T21:02:39.482Z 2555 TID-473tw INFO: Cron Jobs - add job with name: ldap_sync_worker
2016-03-10_21:02:39.48418 2016-03-10T21:02:39.484Z 2555 TID-473tw INFO: Cron Jobs - add job with name: geo_bulk_notify_worker
2016-03-10_21:02:39.50210 could not translate host name "127.0.0.1,104.236.191.64" to address: Name or service not known
2016-03-10_21:02:39.50221 /opt/gitlab/embedded/service/gem/ruby/2.1.0/gems/activerecord-4.2.5.2/lib/active_record/connection_adapters/postgresql_adapter.rb:651:in `initia
lize'