How to call vsql from cygwin under windows?
Im looking for a way to create scripts and schedule jobs from my PC to Vertica running on a Linux server.
I installed the vsql client on my PC. When I try to run the vsql client, it prompts me for a password. However, it just echos the password to the screen as I type then hangs after I hit enter. If I put the "-w" option with the password on the command line, then vsql just hangs.
In both cases, I never get a SQL prompt.
0
Comments
Hi, can you check if you have added the vsql executable to the Windows PATH environment variable? After you have made the change to your PATH environment variable, start a command window and type vsql -? at the command prompt to start vsql.
Also, once you have added the vsql executable to the Windows PATH environment variable, make sure your cygwin.bat file does not include the "tty" flag. Refer this link: https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/ConnectingToVertica/vsql/vsqlNotesForWindowsUsers.htm?TocPath=Connecting%20to%20Vertica|Client%20Libraries|Client%20Drivers|Components%20of%20the%20Client%20Drivers%20and%20Tools%20on%20Windows|The%20vsql%20Client%20for%20Windows|_____1
See if the post here helps...
http://vertica-forums.com/viewtopic.php?f=7&t=2813