Upgrade an environment with another user account

If you upgrade an environment by installing a new version over an old version, you have to use the same user account that was used for the old installation.

However, it is possible that the specific user account is no longer available, for example because the user has left the company. If you upgrade an environment with another user account, you will receive an error message during the procedure:

connection to database failed: FATAL: role "<other user>" does not exist.
could not connect to source postmaster with the command: ...

Tip This is only applicable for Linux operating systems, on Windows you can install with any user who has administrator rights.

Prerequisites

• The Repository service is online.
• You know the password to access the Repository service.

Resolution

1. On the node that hosts the Repository service, open a shell session.
2. Retrieve the username that you will use to upgrade the environment: whoami
   If there is a domain name/username displayed, for example mydomain\john.smith, you can ignore the domain name. The username is john.smith.
3. Go to the repository directory: cd <install location>/collibra/repo/bin, for example cd /opt/collibra/repo/bin
4. Connect to the database using the repository's administrator password.
   A PostgreSQL session starts.
   

   ./psql -p 4403 -U collibra postgres
   Password for user collibra:<repo admin password> 
   psql.bin (10.3)
   Type "help" for help.
   
   Cannot read termcap database;
   using dumb terminal settings.
   postgres=#

5. Update the bootstrap super user with the new username, where you have to replace francois.lemaire by your own username, found in step 2.
   

   update pg_authid set rolname='francois.lemaire' where oid=10;
   
   select rolname from pg_authid where oid=10;

   For example:

   postgres=# update pg_authid set rolname='francois.lemaire' \
       where oid=10;
   UPDATE 1
   postgres=# select rolname from pg_authid where oid=10;
    rolname 
   ---------
    francois.lemaire
   (1 row)

   Make sure that the second command returns the username that you will use to do the upgrade.

6. Leave the PostgreSQL session: \q
7. Close the shell session.
8. In Collibra Console, stop the complete environment and upgrade the environment.