Bryan_H
Administrator
Bryan_H Administrator
Reactions
-
Re: Vertica not restarting smoothly
Are you sure no users are connected, including MC and admintools itself? Check by running SELECT * FROM SESSIONS; If you are certain there are no active users or queries, stop with SQL query SELECT S… (View Post)1 -
Re: How to find invoking user in PL/vSQL procedure with definer security
According to documentation "A procedure with SECURITY DEFINER effectively executes the procedure as that user, so changes to the database appear to be performed by the procedure's definer r… (View Post)1 -
Re: Per-partition storage
In an EE mode database, you can set storage locations for data on local disk and S3, then set a storage policy directing old partitions onto S3 location and a policy for current data on local disk. P… (View Post)1 -
Re: Vertica Backup Objects
Hi, I'm under the impression that backups with restore points only capture deltas but may appear to be full size because the deltas contain "hard links" or filesystem pointers to the m… (View Post)1 -
Re: How To Check if Backup is Taking Place
Try checking the V_MONITOR.SESSIONS table for signs of vbr actions, e.g. mention of "snapshot" in transaction_description or current_statement from a user authorized to run backups: node_na… (View Post)1




















