Postgres issue with upgrade to 10.6

We are having an issue with our Gitlab server after it was upgraded to 10.6. There is an error that is stopping Postgres from starting which states the following:

/var/log/gitlab/postgresql/current

2018-03-23_23:56:22.29013 LOG: skipping missing configuration file “/var/opt/gitlab/postgresql/data/postgresql.auto.conf”
2018-03-23_23:56:22.29070 FATAL: database files are incompatible with server
2018-03-23_23:56:22.29071 DETAIL: The data directory was initialized by PostgreSQL version 9.2, which is not compatible with this version 9.6.8.

Below is the output when trying to run any command on the embedded postgres…

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/tmp/.s.PGSQL.5432”?

Also, upon running gitlab-ctl reconfigure I get the following error:

There was an error running gitlab-ctl reconfigure:

bash[migrate gitlab-rails database] (gitlab::database_migrations line 49) had an error: Mixlib::ShellOut::ShellCommandFailed: Expected process to exit with [0], but received ‘1’
---- Begin output of “bash” “/tmp/chef-script20180324-22706-1676mv9” ----
STDOUT: rake aborted!
PG::ConnectionBad: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/var/opt/gitlab/postgresql/.s.PGSQL.5432”?
/opt/gitlab/embedded/service/gitlab-rails/lib/tasks/gitlab/db.rake:49:in block (3 levels) in <top (required)>' /opt/gitlab/embedded/bin/bundle:23:in load’
/opt/gitlab/embedded/bin/bundle:23:in `’
Tasks: TOP => gitlab:db:configure
(See full trace by running task with --trace)
STDERR:
---- End output of “bash” “/tmp/chef-script20180324-22706-1676mv9” ----
Ran “bash” “/tmp/chef-script20180324-22706-1676mv9” returned 1

Please let me know what other detail is required.

Any help would be appreciated.

@haydursek any update on this? I´m facing the same issue!

I having the same issue if any of you solved it please let me know @haydursek @zazoomauro