Skip to content

It's not possible to set bundled postgres to listen on an IP/Port

The closest I got was:

postgresql['enable'] = true
postgresql['unix_socket_directory'] = "127.0.0.1"
postgresql['port'] = 5432
postgresql['listen_address'] = "127.0.0.1"

which lead to:

2017-07-14_20:42:51.95523 LOG:  configuration file "/var/opt/gitlab/postgresql/data/postgresql.conf" contains errors; unaffected changes were applied

with various iterations of:

2017-07-14_22:14:34.66132 LOG:  parameter "port" cannot be changed without restarting the server
2017-07-14_22:14:34.66132 LOG:  parameter "unix_socket_directories" cannot be changed without restarting the server

Above.

without postgresql['unix_socket_directory'] = "127.0.0.1" set, the following would happen:

 * template[/opt/gitlab/etc/gitlab-psql-rc] action create
    - update content in file /opt/gitlab/etc/gitlab-psql-rc from 4ddaf5 to eaeb56
    --- /opt/gitlab/etc/gitlab-psql-rc    2017-07-14 22:26:14.255382376 +0000
    +++ /opt/gitlab/etc/.chef-gitlab-psql-rc20170714-7345-1chnxvn    2017-07-14 22:39:36.959307141 +0000
    @@ -1,4 +1,4 @@
     psql_user='gitlab-psql'
    -psql_host='127.0.0.1'
    +psql_host='/var/opt/gitlab/postgresql'
     psql_port='5432'

Basically I think:

  1. Docs need to be clarified.
  2. We have to untangle unix_socket_dir in a way that will let us bind to an IP.