We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


VSQL fails in the presence of PostgreSQL environment variables. — Vertica Forum

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 ? 

Comments

  • 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=>

Leave a Comment

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