Skip to main content

VBR replicate errors: non dbadmin user

  • February 22, 2018
  • 1 reply
  • 6 views

RKvertica

Hello - Can Vbr replicate be done using an id other than dbadmin?
A customer tried it and is having issues:

/opt/vertica/bin/vbr -t replicate -c repl_locktable.ini

f401599 is not the owner of /opt/vertica/config/admintools.conf
Error: Error getting cluster information from admintools.

Secondly, if they are running it as dbadmin and wants to specify a different user (source) in the config files, they are getting:
Error 4019 : must be super user to run object snapshot.

Can replicate be run by a user other dbadmin and customer would want that flexibility and not expose dbadmin user for maintenance actvities.

Any limitations /advise?

thanks

1 reply

tharanga
Forum|alt.badge.img
  • Participating Frequently
  • March 6, 2018

Vbr needs to gather cluster details from admintools; hence it should be run as a dbadmin.
During a replication, Vbr has to connect to both source and destination databases to take a snapshot and replicate it. Both operations need to be performed by a superuser or any user that has been granted the pseudosuperuser role.