Site Tools


techsupport:guides:postgresql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
techsupport:guides:postgresql [2019/01/31 14:47] kjohns23techsupport:guides:postgresql [2019/01/31 14:50] (current) kjohns23
Line 7: Line 7:
 ==== Connecting ==== ==== Connecting ====
  
-Connecting to the +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 ==== ==== Common Errors ====
  
-Depending on which machine you are connecting from, you may be presented with the below error message when you try to connect to the Postgres server.+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 <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> GSSAPI continuation error: No Kerberos credentials available (default cache: FILE:/tmp/krb5cc_0000)</code>
  
-If you receive that message, from a terminal enter the command ''%%kinit%%''+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.
techsupport/guides/postgresql.1548946077.txt.gz · Last modified: 2019/01/31 14:47 by kjohns23