Search found 1825 matches

by JimKnicely
Mon Apr 01, 2019 3:26 am
Forum: Vertica Backup & Recovery
Topic: Specialized User for backups (with minimal rights)
Replies: 1
Views: 1432

Re: Specialized User for backups (with minimal rights)

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...
by JimKnicely
Sat Nov 17, 2018 1:05 pm
Forum: Vertica Links
Topic: Master Blog Series: Vertica Database Administrators
Replies: 0
Views: 2722

Master Blog Series: Vertica Database Administrators

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...
by JimKnicely
Fri Oct 19, 2018 5:05 pm
Forum: Announcements, Events and Activities
Topic: Tableau Conference – New Orleans, LA
Replies: 0
Views: 6350

Tableau Conference – New Orleans, LA

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...
by JimKnicely
Thu Sep 27, 2018 4:46 pm
Forum: General
Topic: change active partition (v8.1.1)
Replies: 4
Views: 2091

Re: change active partition (v8.1.1)

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...
by JimKnicely
Wed Sep 26, 2018 4:06 pm
Forum: Vertica Links
Topic: Vertica Tip: Display the Current Statement Number Within the Current Transaction
Replies: 0
Views: 1925

Vertica Tip: Display the Current Statement Number Within the Current Transaction

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...
by JimKnicely
Tue Sep 25, 2018 2:50 pm
Forum: Announcements, Events and Activities
Topic: Subscribe to the Vertica newsletter!
Replies: 0
Views: 1899

Subscribe to the Vertica newsletter!

Vertica Insights Newsletter

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

http://go.microfocus.com/vertica-newsletter-subscribe
by JimKnicely
Tue Sep 25, 2018 2:35 pm
Forum: Vertica Links
Topic: Vertica Tip: Changing the Owner of a View
Replies: 0
Views: 1767

Vertica Tip: Changing the Owner of a View

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

Go to advanced search