Issue with recipe when installing 9.4.5

How to Use GitLab Self-managed
1

Hi!

We are trying to upgrade our instance from 9.4.5 to the latest version of 10.

To do this, I have built a new server (we need to move infrastructure at the same time), installed gitlab-ce 9.4.5 and then intend to import one of our backups. Our postgres install is on a seperate server. I have copied over gitlab.rb from our current live install and changed the postgres values to the new server, and ensured postgresql['enable'] = false

The config looks like this:

gitlab_rails['db_adapter'] = "postgresql"
gitlab_rails['db_encoding'] = "unicode"
gitlab_rails['db_database'] = "gitlabhq_production"
gitlab_rails['db_pool'] = 10
gitlab_rails['db_username'] = "gitlab"
gitlab_rails['db_password'] = "hunter2"
gitlab_rails['db_host'] = "dbservername.com"
gitlab_rails['db_port'] = 5432
gitlab_rails['db_socket'] = nil

At the point of running gitlab-ctl reconfigure, it fails with the following:

192.168.1.2 is the (redacted) IP of the gitlab server and not the postgres server, as I would expect. postgres is not installed and it enable is set to false in the config file.

Recipe: gitlab::postgresql_disable
  * link[/opt/gitlab/service/postgresql] action delete (up to date)
  * directory[/opt/gitlab/sv/postgresql] action delete (up to date)
Recipe: gitlab::database_migrations
  * bash[migrate gitlab-rails database] action run
    [execute] rake aborted!
              PG::ConnectionBad: FATAL:  no pg_hba.conf entry for host "192.168.1.2", user "gitlab", database "gitlabhq_production", SSL on
              FATAL:  no pg_hba.conf entry for host "192.168.1.2", user "gitlab", database "gitlabhq_production", SSL off
              /opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:49:in `block (3 levels) in <top (required)>'
              /opt/gitlab/embedded/bin/bundle:22:in `load'
              /opt/gitlab/embedded/bin/bundle:22:in `<main>'
              Tasks: TOP => gitlab:db:configure
              (See full trace by running task with --trace)

    ================================================================================
    Error executing action `run` on resource 'bash[migrate gitlab-rails database]'
    ================================================================================

This also happens if I run gitlab-rake gitlab:setup and gitlab-rake gitlab:env:info. If I try to start gitlab, only redis comes up.

I’m at a loss as to why this may be occuring as I can find no trace of any reference to using local postgres in the config, that should be disabled, and it isn’t even installed.

Any help would be greatly appreciated.

2

As usual, found the solution just after posting!

3

For any interested parties, the solution was that I hadn’t changed the IP address of the gitlab server in pg_hba.conf to that of the new host.

4

Hi,

Could you please let me know the exact change ?

Where to give the IP address of the gitlab server in pg_hba.conf ?

Appreciate your response