Differences

This shows you the differences between two versions of the page.

--- techsupport:guides:postgresql [2019/01/31 14:42] – created kjohns23
+++ techsupport:guides:postgresql [2019/01/31 14:50] (current) – kjohns23
@@ Line 1: / Line 1: @@
 ===== 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:
+<code>psql -h db</code>
+==== 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.
+<code>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)</code>
+If you receive that message, from a terminal enter the following command <code>kinit</code>
+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.