Cool, thanks Jim!

Hi,

Does anyone know if the check_spread tool of the admintools utility checks spread on all nodes or just the node where I am running the command?

Hey, Anyone know what the barrier function does? dbadmin=> \df barrier List of functions procedure_name | procedure_return_type | procedure_argument_types ----------------+-----------------------+-------------------------- barrier | Varchar | Varchar, Varchar (1 row) dbadmin=> select barrier('becky'...

Ok, so I deleted the following three directories and re-ran the backup command and it worked. [dbadmin@vertica01 vertica_backups]$ rm -fR v_sales_db_node0001 [dbadmin@vertica01 vertica_backups]$ rm -fR v_sales_db_node0002 [dbadmin@vertica01 vertica_backups]$ rm -fR v_sales_db_node0003 [dbadmin@verti...

Hi sKwa, I tried delete all the files in that directory manually and re-ran the backup command... [dbadmin@vertica01 ~]$ ls -lrt /home/dbadmin/vertica_backups/v_snowfall_node0001 total 0 [dbadmin@vertica01]$ /opt/vertica/bin/vbr.py --task backup --config-file /home/dbadmin/vertica_backups/sales_db_f...

Hi, I am getting errors when trying to backup a three node cluster: rmdir: failed to remove `/home/dbadmin/vertica_backups/v_sales_db_node0001/.sales_db_full.done': Directory not empty Traceback (most recent call last): File "/opt/vertica/bin/vbr.py", line 1971, in backup remoteCopyAll() File "/opt/...

Hey sKwa! That's a great idea about using crontab. So you think I can just run a vsql command to alter the user's default resource pool? What if the user is is logged on at the time I change the resource pool? Does the change take effect immediately or would they have to log out and log back in?