Skip to main content

VSQL fails in the presence of PostgreSQL environment variables.

  • January 7, 2015
  • 1 reply
  • 7 views
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 ? 

    1 reply

    id10t
    Forum|alt.badge.img
    • id10t
    • Participating Frequently
    • January 7, 2015
    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=>

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement