We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


VBR replicate errors: non dbadmin user — Vertica Forum

VBR replicate errors: non dbadmin user

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

Comments

  • 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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file