Error: "Could not write test file..." when installing or upgrading to 5.8

When you install 5.8 or upgrade to 5.8 on Linux, you have to install PostgreSQL 11 as a prerequisite. If you don't complete all steps, you may encounter the following error message:

Could not write test file to validate postgresql-related permissions, check write access for 'collibra' user to /run/postgresql

Resolution

Make sure that:

• you have installed PostgreSQL 11 correctly.
• you have updated the PostgreSQL configuration file, this file must contain the following line:

  #update this line:
  d /run/postgresql 0755 postgres postgres -
  			
  #to:
  d /run/postgresql 2777 postgres postgres - -

• you have restarted the server.

#correct permissions:
drwxrwsrwx.  2 postgres       postgres         40 Dec 20 07:51 postgresql

#wrong permissions:
drwxr-xr-x.  2 postgres       postgres         40 Dec 20 07:46 postgresql