Hi, Only the database admin account (i.e. dbadmin) can backup the database. If you are concerned about the password being saved in the config file, use a Password Configuration File instead. See: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/PasswordConf...

Are you a database administrator looking for ways to get the most from your Vertica database? If so, this post is for you. You’re already familiar with the technicalities of Vertica – the Tuple Mover, deletes, projections, and more. If you’re looking to get started, check out our master blog for new...

Tableau Conference – New Orleans, LA Vertica will be a Megabyte Sponsor at the upcoming Tableau Conference October 22 – 25th in New Orleans. Thousands of analytics-obsessed attendees from every industry and discipline will be there, hungry for solutions to help them leverage their investment in Tab...

Hi, You can now set the Active Partition Count at the table level. See: https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Partitions/ActivePartitions.htm From the doc: Note: For tables partitioned by non-temporal attributes, set its active partition count to reflect the...

A Transaction in Vertica is one or more operations that are executed as a unit of work. At the user level, transactions occur in the current session by a user or script running one or more SQL statements. A transaction has a unique Transaction ID and the “units of work” within a transaction are each...

Vertica Insights Newsletter

Sign up below to receive monthly updates and articles about Vertica!

http://go.microfocus.com/vertica-newsletter-subscribe

We can change the owner of a database view with the ALTER VIEW … OWNER TO command.

Read more here:
https://forum.vertica.com/discussion/23 ... -of-a-view