Page 1 of 1
Connecting to DB from MC cannot see tables in DB
Posted: Fri Mar 15, 2013 6:45 pm
by clv100
I am VERY new at this. I am logged into the Management Console node. I enter vsql and enter the connection string to the database. It confirms "CONNECT". However, if I try to view the tables in the database, I only see the tables from the Management Console node. Can you tell me what I am doing wrong?? Thanks!!!
Re: Connecting to DB from MC cannot see tables in DB
Posted: Fri Mar 15, 2013 8:49 pm
by JimKnicely
Hi!
If you want to connect to your Vertica DB from the MC server, use the -h (host) option of vsql.
From the Linux command prompt on your MS server, try something like this:
vsql -h hostname -U username -w password
hostname = The IP or host name of any of the nodes in your DB cluster
username = The DB user you want to connect with
password = Password of that user
I hope this helps!
Re: Connecting to DB from MC cannot see tables in DB
Posted: Tue Mar 19, 2013 6:13 pm
by clv100
Got it!! Thanks!!