PostgreSQL

PostgreSQL is a database management system allowing custom types, triggers and table inheritance.

PostgreSQL Services in CSCF

CSCF operates three principal database clusters:

Access to CSCF database clusters is restricted to on-campus.

For information on personal database set up, see PostgresPersonalDatabases.

Usage

For Ubuntu one should become the user postgres and then run psql, the command line tool to access PostgreSQL. If one becomes the Unix user postgres, or if one uses sudo
sudo -u postgres psql

which results in the command line prompt:

Welcome to psql 8.2.4, the !PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=# \l
        List of databases
   Name    |  Owner   | Encoding 
-----------+----------+----------
 postgres  | postgres | UTF8
 template0 | postgres | UTF8
 template1 | postgres | UTF8
(3 rows)

postgres=# 

Setup

See PostgreSQLSetup.

Alternatives

Other DBMS's varying in their scope of application, licensing etc. are MySQL, DB2, Oracle, Apache Derby. See comparison of systems on Wikipedia,

References

Topic revision: r13 - 2016-12-05 - DanielAllen
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback