SUNScholar/Disaster Recovery/Preparation

Back to Disaster Recovery - System Monitor Client

Back to Disaster Recovery - Local Backup Script

PostgreSQL Database Credentials
Create a credentials file for the postgres or dspace user. See: Open a terminal on the server and type the following:
 * http://www.postgresql.org/docs/9.1/interactive/libpq-pgpass.html
 * http://www.pgadmin.org/docs/1.4/pg/libpq-pgpass.html

To become the postgres user. su - postgres

To create the credential file type. nano ~/.pgpass

Copy and paste the following into the file: localhost:5432:dspace:dspace:dspace This file should contain lines of the following format: hostname:port:database:username:password

To lock down file permissions type. chmod 0600 ~/.pgpass

To test type. psql

You should be automatically connected to the database now.

To quit the database type. \q