Search found 19 matches

by rajaduraibanu
Wed Sep 25, 2013 12:40 pm
Forum: Vertica Backup & Recovery
Topic: Unable to connect to db , while taking backup
Replies: 7
Views: 34102

Re: Unable to connect to db , while taking backup

hi , i created password less ssh connection even then getting same error :( What is that .info file , what should be its content ??? and now i modified snapshot name in config file as snapshotName = VerticaBkp now my error is as below ./vbr.py --task backup --config-file /home/dbadmin/VerticaBkp.ini...
by rajaduraibanu
Wed Sep 25, 2013 10:00 am
Forum: Vertica Backup & Recovery
Topic: Unable to connect to db , while taking backup
Replies: 7
Views: 34102

Unable to connect to db , while taking backup

hi i created configuration file using vbr.py and now trying to take entire backup of my single node Vertica db using vbr.py but m getting below error ./vbr.py --task backup --config-file /home/dbadmin/VerticaBkp.ini Preparing... Found Database port: 5433 Traceback (most recent call last): File "./vb...
by rajaduraibanu
Wed Sep 18, 2013 10:59 am
Forum: Vertica External Procedures
Topic: Err when calling script through external procedure
Replies: 4
Views: 19881

Re: Err when calling script through external procedure

hi
I got the solution , Need to specify commit also in the query ...
Now everything is working fine :)
by rajaduraibanu
Tue Sep 17, 2013 10:00 am
Forum: Vertica External Procedures
Topic: Err when calling script through external procedure
Replies: 4
Views: 19881

Re: Err when calling script through external procedure

Now m able to select values and write into file and Create table too .. But Not able to do insert , update and delete operations . Any permission need to b given ??? when i execute procedure on db console m getting output as 0 , that mean its executed perfectly and inside file it is writing as OUTPU...
by rajaduraibanu
Tue Sep 17, 2013 7:46 am
Forum: Vertica External Procedures
Topic: Err when calling script through external procedure
Replies: 4
Views: 19881

Re: Err when calling script through external procedure

No actuaaly i don need to print or see ma output , But for insert operation it shuld insert a row right .
That is not happening .
by rajaduraibanu
Tue Sep 17, 2013 5:57 am
Forum: Vertica External Procedures
Topic: Err when calling script through external procedure
Replies: 4
Views: 19881

Err when calling script through external procedure

HI My procedure is as below #!/bin/bash us="dbadmin" pw="tdadb" PORT=5433 VSQL="/opt/vertica/bin/vsql" myvsql="$VSQL -A $us $pw -c " $myvsql " select * from table; " >> /opt/etl/etc/files/selectop 2>&1 exit 0 ------------------------------------------------------------- If i execute the script m get...
by rajaduraibanu
Thu Sep 05, 2013 11:18 am
Forum: Perl
Topic: ODBC buffer size
Replies: 3
Views: 63002

Re: ODBC buffer size

mmm ya thank u :)

Go to advanced search