PostgreSQL 13.4-GCCcore-11.2.0PostgreSQL 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.
Accessing PostgreSQL 13.4-GCCcore-11.2.0
To load the module for PostgreSQL 13.4-GCCcore-11.2.0 please use this command on the BEAR systems (BlueBEAR, BEARCloud VMs, and CaStLeS VMs):
module load bear-apps/2021b
module load PostgreSQL/13.4-GCCcore-11.2.0
BEAR Apps Version
EL8-cascadelake — EL8-haswell — EL8-icelake
The listed architectures consist of two part: OS-CPU.
- BlueBEAR: The OS used on BlueBEAR is represented by EL and there are several different processor (CPU) types available on BlueBEAR. More information about the processor types on BlueBEAR is available on the BlueBEAR Job Submission page.
- BEAR and CaStLeS Cloud VMs: These VMs can have one of two OSes. Those with access to a BEAR Cloud or CaStLeS VM should check that the listed architectures for an application include the OS of VM being used. The VMs, irrespective of OS, will use the haswell CPU type.
For more information visit the PostgreSQL website.
This version of PostgreSQL has a direct dependency on: GCCcore/11.2.0 libreadline/8.1-GCCcore-11.2.0 OpenSSL/1.1 zlib/1.2.11-GCCcore-11.2.0
This version of PostgreSQL is a direct dependent of: psycopg2/2.9.5-GCCcore-11.2.0 QGIS/3.28.1-foss-2021b SOCI/4.0.3-GCC-11.2.0
These versions of PostgreSQL are available on the BEAR systems (BlueBEAR, BEARCloud VMs, and CaStLeS VMs). These will be retained in accordance with our Applications Support and Retention Policy.
|Version||BEAR Apps Version|
Last modified on 7th July 2022