VSQL fails in the presence of PostgreSQL environment variables.

Ablimit_Aji

I have PostgreSQL and Vertica installed on an Ubuntu System. For convenience, I have used few PostgreSQL and Vertica environment variables (username, dbname, port, and db_installation_home).

However, vsql fails while the PostgreSQL environment variables are present. 
What could be the problem ? 

id10t

Hi!

What could be the problem ? 

vsql based on psql, actually vsql is a clone of psql.
While psql can easily connect to Vertica (and PG via  DBLink too) you can use in psql only.
Due establishing a connection psql may be will throw few errors, but its not critical, you still can work with Vertica with psql:

daniel@synapse:~$ /usr/bin/psql -V
psql (PostgreSQL) 9.3.5
daniel@synapse:~$ /usr/bin/psql -h localhost -p 5433 -U daniel
psql (9.3.5, server v7.1.1-2)
Type "help" for help.

daniel=> select version();
              version               
------------------------------------
 Vertica Analytic Database v7.1.1-2
(1 row)

daniel=>