Difference between revisions of "PostgreSQL"

From Dryad wiki
Jump to: navigation, search
(Postgres configuration)
(Postgres configuration)
(One intermediate revision by the same user not shown)
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/
* To use the postgres account in the database, must be logged in to the postgres account in the shell, then just run 'pgsql'
* To be sure to stop postgres, login to the postgres shell account and run /usr/pgsql-9.5/bin/pg_ctl stop -D /var/lib/pgsql/9.5/data
== See Also ==
== See Also ==

Latest revision as of 12:34, 21 February 2018

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.
List all tables in the database
help with postgres
help with sql

See Also