Connecting to DB from MC cannot see tables in DB
Moderator: NorbertKrupa
Connecting to DB from MC cannot see tables in DB
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!!!
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Connecting to DB from MC cannot see tables in DB
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!
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!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Connecting to DB from MC cannot see tables in DB
Got it!! Thanks!!