Difference between revisions of "PostgreSQL"

From Dryad wiki
Jump to: navigation, search
(Common Commands)
Line 9: Line 9:
 
; \q : quit
 
; \q : quit
 
; \? : help with sql
 
; \? : help with sql
 +
 +
== Postgres configuration ==
 +
 +
On the NCSU servers:
 +
* binaries /usr/pgsql-9.0
 +
* data /var/lib/pgsql/9.0/data
 +
* automatic backups in /var/lib/pgsql/9.0/backups/
  
 
[[Category:Software]]
 
[[Category:Software]]
 
[[Category:Technical Documentation]]
 
[[Category:Technical Documentation]]

Revision as of 12:18, 8 July 2016

DSpace uses the PostgreSQL database by default.

Common Commands

\c [name]
Connect to a database (like "dspace")
\d [name]
Describes the format of a table, view, sequence, etc.
\dt
List all tables in the database
\h 
help with postgres
\q 
quit
\? 
help with sql

Postgres configuration

On the NCSU servers:

  • binaries /usr/pgsql-9.0
  • data /var/lib/pgsql/9.0/data
  • automatic backups in /var/lib/pgsql/9.0/backups/