SUNScholar/Disaster Recovery/Preparation

Back to Disaster Recovery System Monitor Client

PostgreSQL Database Credentials

Create a credentials file for the postgres or dspace user. See:

• http://www.postgresql.org/docs/9.1/interactive/libpq-pgpass.html
• http://www.pgadmin.org/docs/1.4/pg/libpq-pgpass.html

Open a terminal on the server and type the following:

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 connected to the database now.

To quit the database type.

\q