From Dryad wiki
Revision as of 12:18, 8 July 2016 by Ryan Scherle
DSpace uses the PostgreSQL database by default.
- \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
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/