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.
Extensive on-line documentation is available. For questions about PostgreSQL at NERSC, please contact firstname.lastname@example.org.
psql is available on login to Cori and Edison, you do not need to load a module