Attention

Following the recent operating system upgrade, software listings and module load commands now reflect the upgraded system. Some examples and notices are still being updated and may contain outdated guidance.

PostgreSQL

PostgreSQL is a powerful, open source object-relational database system. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

Note

This is an autogenerated page, more detail including examples may be available for this package. Please see the first section of Software on Stanage

After connecting to Stanage (see Establishing a SSH connection), start an interactive session with the following command:

srun --pty bash -i

A version of PostgreSQL can then be made available with one of the following:

module load PostgreSQL/16.4-GCCcore-13.3.0

Notes

PostgreSQL was installed using Easybuild, build details can be found in $EBROOTPOSTGRESQL/easybuild with a given module loaded.

Direct dependencies for latest version of PostgreSQL