I have a DEV Vertica database and need to create a new TST Vertica database.
During the past few months both administrators and users have had pretty-much wide open access to do what ever was needed to get things working. Thus, the internal Vertica configuration/metadata is not well tracked nor understood.
Im looking for a way to export all the internal configuration details and metadata needed to 1) Document what the current configuration is, and 2) Deploy that configuration to a new TST Vertica database.
Some of the things I am looking for are:
1. ACCESS/Authentication/LDAP config
2. Profiles/Resource/Roles/Users/Options
3. Object DDL, Flex tables, Schemas, Sequences
4. Anything else metadata related to be able to
document/reproduce the configuration.
Asked by Ron Watkins
(21 rep)
Apr 24, 2018, 03:55 PM
Last activity: Apr 11, 2019, 02:17 PM
Last activity: Apr 11, 2019, 02:17 PM