1 Recipe: gitlab::postgresql 2   * template[/opt/gitlab/etc/gitlab-psql-rc] action create (up to date) 3   * execute[create gitlab database user] action run 4     [execute] psql: could not connect to server: Connection refused 5                   Is the server running locally and accepting 6                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"? 7     [execute] psql: could not connect to server: Connection refused 8                   Is the server running locally and accepting 9                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?10     [execute] psql: could not connect to server: Connection refused11                   Is the server running locally and accepting12                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?13     [execute] psql: could not connect to server: Connection refused14                   Is the server running locally and accepting15                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?16     [execute] psql: could not connect to server: Connection refused17                   Is the server running locally and accepting18                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?19     [execute] psql: could not connect to server: Connection refused20                   Is the server running locally and accepting21                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?22     [execute] psql: could not connect to server: Connection refused23                   Is the server running locally and accepting24                   connections on Unix domain socket "/var/opt/gitlab/postgresql/.s.PGSQL.5432"?25     [execute] psql: could not connect to server: Connection refused

2017-06-05_07:49:01.37753 FATAL:  pre-existing shared memory block (key 5432001, ID 0) is still in use2017-06-05_07:49:01.37754 HINT:  If you‘re sure there are no old server processes still running, remove the shared memory block or just delete the file "postmaster.pid".

root@ubuntu-70:/var/opt/gitlab/postgresql/data#  rm postmaster.pid