One of the reasons is that old installations still expect to see a trigger file in /tmp/postgresql.trigger while now the path is /var/opt/gitlab/postgresql/data/postgresql.trigger
/tmp/postgresql.trigger
/var/opt/gitlab/postgresql/data/postgresql.trigger