Upgrade 7.12.2 Omnibus issues

Hi,
I’m having lot’s of trouble upgrading my 7.12.2 omnibus setup. I feels like an issue with the DB migration but I can’t seem to pinpoint it. Are there any specific steps to consider when migrating from 7.12.2 to the latest version (today 7.14.1).

my gitlab.rb file is mostly default: most entries are commented out (including the db_host entries).

# 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’] = nil
# gitlab_rails[‘db_host’] = nil
# gitlab_rails[‘db_port’] = 5432
# gitlab_rails[‘db_socket’] = nil

After trying several times using yum install, I tried downloading the package and use rpm instead. The output is below

Thanks!

Preparing… ########################################### [100%]
gitlab preinstall: Backing up GitLab SQL database (excluding Git repositories, uploads)
Dumping database …
Dumping PostgreSQL database gitlabhq_production … pg_dump: [archiver (db)] connection to database “gitlabhq_production” failed: 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”?
[FAILED]
Backup failed
gitlab preinstall:
gitlab preinstall: Backup failed! If you want to skip this backup, run the following command and
gitlab preinstall: try again:
gitlab preinstall:
gitlab preinstall: sudo touch /etc/gitlab/skip-auto-migrations
gitlab preinstall:
error: %pre(gitlab-ce-7.14.1-ce.0.el6.x86_64) scriptlet failed, exit status 1
error: install: %pre scriptlet failed (2), skipping gitlab-ce-7.14.1-ce.0.el6
[root@legs ~]# yum list installed | grep gitlab
gitlab-ce.x86_64 7.12.2~omnibus-1 @gitlab_gitlab-ce

Got the same issue today. After checking the status of Gitlab. I found that PostgreSQL was down. So manually start PostgreSQL solved this problem.

Hi @fkj,

happy to hear I’m not the only one facing this issue. Unfortunately I’m not very familiar with PostgreSQL.
Can you tell me how to manually start it ? And also, would it come up automatically the 2nd time around or do you need to manually start it every single time?

Thx !