pg-upgrade command does not use configured user
Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.
Running pg-upgrade does not pull in the configured user for postgres. We use the user postgres, the script tried using gitlab-psql
gitlab version 9.4.7
Logs [clasater@gitlab ~]$ sudo gitlab-ctl pg-upgrade Checking for an omnibus managed postgresql: OK Checking if we already upgraded: NOT OK Checking for a newer version of PostgreSQL to install: OK Upgrading PostgreSQL to 9.6.3 Checking if PostgreSQL bin files are symlinked to the expected location: OK Toggling deploy page:cp /opt/gitlab/embedded/service/gitlab-rails/public/deploy.html /opt/gitlab/embedded/service/gitlab-rails/public/index.html Toggling deploy page: OK Toggling services:ok: down: gitaly: 0s, normally up ok: down: logrotate: 1s, normally up ok: down: mailroom: 0s, normally up ok: down: registry: 1s, normally up ok: down: sidekiq: 1s, normally up Toggling services: OK Waiting 30 seconds to ensure tasks complete before PostgreSQL upgrade Please hit Ctrl-C now if you want to cancel the upgrade Stopping the database:ok: down: postgresql: 0s, normally up Stopping the database: OK Update the symlinks: OK Creating temporary data directory:Error creating new directory: /var/opt/gitlab/postgresql/data.9.6.3 STDOUT: STDERR: su: user gitlab-psql does not exist Creating temporary data directory: NOT OK == Fatal error == Please check the output == Reverting == ok: down: postgresql: 1s, normally up ok: run: postgresql: (pid 51247) 1s == Reverted == == Reverted to 9.2.18. Please check output for what went wrong == Toggling deploy page:rm -f /opt/gitlab/embedded/service/gitlab-rails/public/index.html Toggling deploy page: OK Toggling services:ok: run: gitaly: (pid 89353) 0s ok: run: logrotate: (pid 110099) 1s ok: run: mailroom: (pid 131149) 0s ok: run: registry: (pid 151536) 1s ok: run: sidekiq: (pid 171727) 0s Toggling services: OK
Configs: gitlab_rails['db_adapter'] = "postgresql" postgresql['data_dir'] = "/var/opt/gitlab/postgresql/data" postgresql['dir'] = "/var/opt/gitlab/postgresql" postgresql['effective_cache_size'] = "1MB" postgresql['enable'] = true postgresql['gid'] = 26 postgresql['ha'] = false postgresql['home'] = "/var/opt/gitlab/postgresql" postgresql['log_directory'] = "/var/log/gitlab/postgresql" postgresql['max_connections'] = 200 postgresql['port'] = 5432 postgresql['shared_buffers'] = "2GB" postgresql['shell'] = "/bin/sh" postgresql['sql_ci_user'] = "gitlab_ci" postgresql['sql_user'] = "gitlab" postgresql['svlogd_filter'] = "gzip" postgresql['svlogd_num'] = 10 postgresql['svlogd_size'] = 10240000 postgresql['uid'] = 26 postgresql['user_path'] = "/opt/gitlab/embedded/bin:/opt/gitlab/bin:$PATH" postgresql['username'] = "postgres" postgresql['work_mem'] = "8MB" gitlab_ci['db_adapter'] = "postgresql"