NERSCPowering Scientific Discovery Since 1974

PostgreSQL

Description and Overview

PostgreSQL is an object-relational database. It is known for having powerful and advanced features and extensions as well as supporting SQL standards.

NERSC provides a set of database nodes for users that wish to use PostgreSQL with their scientific applications.

Requesting a PostgreSQL Database

Users can request a PostgreSQL database for their project using this form.

How to Use PosgreSQL 

The psql command line client is available at NERSC on Hopper, and Edison, and can be used to directly connect to a Postgres database via the command line. The system version of the client is 9.1 so if you use this to connect to the NERSC posgres (scidb) servers which are at version 9.4 then you will get a warning. You can get a v9.4 client on Edison by loading the module

module load postgresql 

On a NERSC system, type the following commands to use the psql command line client:

% psql -h scidb1.nersc.gov yourdb dbuser

Replace yourdb and dbuser with the name of the database and user provided to you by NERSC.
You may need to replace scidb1 with scidb2. 

Documentation

Extensive on-line documentation is available.  For questions about PostgreSQL at NERSC, please contact consult@nersc.gov.

Availability

psql is available on login to Cori and Edison, you do not need to load a module