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.
How to call vsql from cygwin under windows?
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
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
