Search found 19 matches
- Wed Sep 25, 2013 12:40 pm
- Forum: Vertica Backup & Recovery
- Topic: Unable to connect to db , while taking backup
- Replies: 7
- Views: 34022
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...
- Wed Sep 25, 2013 10:00 am
- Forum: Vertica Backup & Recovery
- Topic: Unable to connect to db , while taking backup
- Replies: 7
- Views: 34022
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...
- Wed Sep 18, 2013 10:59 am
- Forum: Vertica External Procedures
- Topic: Err when calling script through external procedure
- Replies: 4
- Views: 19819
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
I got the solution , Need to specify commit also in the query ...
Now everything is working fine
- Tue Sep 17, 2013 10:00 am
- Forum: Vertica External Procedures
- Topic: Err when calling script through external procedure
- Replies: 4
- Views: 19819
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...
- Tue Sep 17, 2013 7:46 am
- Forum: Vertica External Procedures
- Topic: Err when calling script through external procedure
- Replies: 4
- Views: 19819
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 .
That is not happening .
- Tue Sep 17, 2013 5:57 am
- Forum: Vertica External Procedures
- Topic: Err when calling script through external procedure
- Replies: 4
- Views: 19819
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...
- Thu Sep 05, 2013 11:18 am
- Forum: Perl
- Topic: ODBC buffer size
- Replies: 3
- Views: 62892
Re: ODBC buffer size
mmm ya thank u