You must connect to a Hartford cmapus UNIX workstation to access the PostgreSQL client software. The remote access host is sparky.ewp.rpi.edu
You will need three things. Secure-Shell cleint software on your local computer. You need to know your username and password for both PostgreSQL and your Hartford Network Account, which is different from your Troy campus account.
For more information on creating a Secure-Shell connection from a MS Windows or MacOS, read this PDF file: SShell_setup_ Instructions.pdf
For more information about getting both your PostgreSQL and Hartford Network Account informaiton; Click Here
For more information about UNIX commands, read this tutorial.
$ ssh sparky.ewp.rpi.edu
Once connected to the host computer, and you are at a UNIX command prompt. You will next connect to another internal RPI host called, VNC1-112.
$ ssh vnc1-112
To start the ad-hoc PostgreSQL command line tool you will need your PostgreSQL username and password. These are normally your Hartford campus Network username and password.
To connect to the local database with PostgreSQL command line tool, type (with out the quote marks), ‘psql db1’. This will place you in your own schema, with in the common database called DB1. You only have permissions with in your own schema.
$ psql db1
After successful login you should see the PostgreSQL prompt db1=>:
psql Type "help" for help. db1=>