Can the dradmin linux user account be changed to another user?

Products

• CA Performance Management
• Network Observability

Issue/Introduction

When installing Performance Management I used dradmin as the DbAdminLinuxUser. What step(s) should I take to change the username?  Newly installed system and forgot to use a service account user instead of the default dradmin.

Environment

All supported Performance Management releases

Cause

 Newly installed system and forgot to use a service account user instead of the default dradmin.

Resolution

Changing the OS dbadmin user on a running database is not possible.
You can only define it through install_vertica script while initially setting up the database.

Once the database is already running, it is not feasible to modify the OS dbadmin user.
You can create a database user with the same permissions as the dbadmin user but not OS dbadmin user.

If you wanted to change the user, the best way to do that would be to back up the DR database (vertica) and then uninstall/reinstall with the correct OS/DB user and load the database backup into the newly created database.  Also, DA dbconnection.cfg would need to be changed to the new dbadmin username/password.