I tried to upgrade discourse and got the following message -
I, [2021-01-21T18:39:25.045454 #1] INFO -- : > cd /var/www/discourse && su discourse -c 'bundle exec rake db:migrate' 2021-01-21 18:39:32.724 UTC  discourse@discourse LOG: duration: 336.116 ms statement: UPDATE users SET locale = 'en_GB' WHERE locale = 'en' 2021-01-21 18:39:33.373 UTC  discourse@discourse ERROR: duplicate key value violates unique constraint "index_users_on_username_lower" 2021-01-21 18:39:33.373 UTC  discourse@discourse DETAIL: Key (username_lower)=(xyz123) already exists. 2021-01-21 18:39:33.373 UTC  discourse@discourse STATEMENT: UPDATE users SET locale = 'en' WHERE locale = 'en_US' rake aborted! StandardError: An error has occurred, this and all later migrations canceled:
I tried to do
./launcher enter app and
su postgres -c 'psql discourse', got the following error -
psql: error: could not connect to server: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”?