SW:PostgreSQL
PostgreSQL
Description
PostgreSQL is a powerful, open source object-relational database system.
- Homepage: https://www.postgresql.org//
Access
PostgreSQL is open to all HPRC users.
PostgreSQL Module
TAMU HPRC currently supports the user of PostgreSQL though the PostgreSQL modules. There are a variety of Anaconda modules available on Ada and Terra.
You can learn more about the module system on our SW:Modules page.
PostgreSQL on Ada
1) module load PostgreSQL/9.6.1-GCCcore-6.3.0-Python-2.7.12-bare (2) initdb -D /scratch/user/yangliu/Test/postresql/test.db (3) pg_ctl -o "-p 9999" -D /scratch/user/yangliu/Test/postresql/test.db -l /scratch/user/yangliu/Test/postresql/test.log start #comment: the -o provides extra options. In this example, the extra option is the port by -p. the -D option specified where is the database file. The -l option specify the log file for the database instance. (4) createdb yang -D /scratch/user/yangliu/Test/postresql/test.db -p 9999 (5) psql -d yang -p 999 (6) execute your sql statments in psql (7) pg_ctl -D /scratch/user/yangliu/Test/postresql/test.db stop