Hprc banner tamu.png

SW:PostgreSQL

From TAMU HPRC
Revision as of 08:44, 29 March 2018 by Yangliu (talk | contribs) (Created page with "=PostgreSQL= __TOC__ ==Description== PostgreSQL is a powerful, open source object-relational database system. * Homepage: [https://www.postgresql.org// https://www.postgresql...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

PostgreSQL

Description

PostgreSQL is a powerful, open source object-relational database system.

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