Table of Contents
SoCS Postgresql Database
Overview
Students enrolled in CIS*2750 or later have access to a Postgres database. The database name is the same as your Central Login Username. Students are unable to create additional databases, but can create tables as needed within their provided database.
Connecting
Connecting to the SoCS Postgres Server can only be done from the SoCS Linux Cluster (SSH or NoMachine). To connect, run the following command from the terminal:
psql -h db
Common Errors
Due to the way connecting is configured, you may be presented with the below error message when you try to connect to the Postgres server.
psql: GSSAPI continuation error: Unspecified GSS failure. Minor code may provide more information GSSAPI continuation error: No Kerberos credentials available (default cache: FILE:/tmp/krb5cc_0000)
If you receive that message, from a terminal enter the following command
kinit
You will be prompted to enter your Central Login Password. Once you have done so you can then attempt to connect to the database server.