VSQL fails in the presence of PostgreSQL environment variables.

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 ? 


  • Options
    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();
    Vertica Analytic Database v7.1.1-2
    (1 row)


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file