Postgresql 9.6 upgrade failed with tmp-dir
Looks like an issue with permissions on my tmp-dir
. What should the permissions for that dir be? Also do I need to create the folder or will the upgrader do that?
[user@gitlabdev1 app]$ sudo gitlab-ctl pg-upgrade --tmp-dir /app/postgresql-upgrade-tmp
Checking for an omnibus managed postgresql: OK
Checking version of running PostgreSQL: OK
Checking for a newer version of PostgreSQL to install: OK
Upgrading PostgreSQL to 9.6.1
Checking if existing PostgreSQL instances needs to be upgraded: OK
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: 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: OK
Initializing the new database:Error initializing database for 9.6.1
STDOUT: The files belonging to this database system will be owned by user "gitlab-psql".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
STDERR: initdb: could not access directory "/app/postgresql-upgrade-tmp/data.9.6.1": Permission denied
== Fatal error ==
Please check the output and try again
== Reverting ==
ok: down: postgresql: 1s, normally up
ok: run: postgresql: (pid 19884) 0s
== 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: logrotate: (pid 19896) 0s
ok: run: mailroom: (pid 19904) 0s
ok: run: registry: (pid 19907) 1s
ok: run: sidekiq: (pid 19920) 0s
Toggling services: OK