yaaa tdadb is present and active

im executing this command vbr.py -t backup --config-file /opt/etl/tmp/back.ini

getting following ERROR:

Preparing...
Cannot find tdadb; can only backup to an existing database.
backup failed!

hi

How to back up vertica db using vbr.py script

Hi

What is the command used to view the external procedures created ?

No actually my doubt is similar to SGA parameter in oracle is there any parameter in Vertica to increase ODBC Buffer size .


reply soon

hi

how to change SGA parameter of the database and what is the default value ?

i tried using \i command but i got an error as below

dbadmin=> \i vmart_queries_explain.sql
vmart_queries_explain.sql: No such file or directory

the sql file is in this path /opt/vertica/examples/VMart_Schema

what is to be done ?