Difference between revisions of "SUNScholar/Disaster Recovery/Preparation"
Jump to navigation
Jump to search
m |
m |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<center> | <center> | ||
| − | '''[[SUNScholar/Disaster Recovery/System Monitor/Client|Back to Disaster Recovery System Monitor Client]]''' | + | '''[[SUNScholar/Disaster Recovery/System Monitor/Client|Back to Disaster Recovery - System Monitor Client]]''' |
| + | |||
| + | '''[[SUNScholar/Disaster Recovery/Backups/Local|Back to Disaster Recovery - Local Backup Script]]''' | ||
</center> | </center> | ||
| Line 18: | Line 20: | ||
Copy and paste the following into the file: | Copy and paste the following into the file: | ||
localhost:5432:dspace:dspace:dspace | localhost:5432:dspace:dspace:dspace | ||
| − | This file should contain lines of the following format: ''hostname:port:database:username:password'' | + | This file should contain lines of the following format: '''''hostname:port:database:username:password''''' |
To lock down file permissions type. | To lock down file permissions type. | ||
| Line 26: | Line 28: | ||
psql | psql | ||
| − | You should be connected to the database now. | + | You should be automatically connected to the database now. |
To quit the database type. | To quit the database type. | ||
'''\q''' | '''\q''' | ||
| + | [[Category:System Administration]] | ||
Latest revision as of 11:18, 28 May 2016
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:
- 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 automatically connected to the database now.
To quit the database type.
\q
