Difference between revisions of "SUNScholar/Disaster Recovery/Preparation"
Jump to navigation
Jump to search
m (Text replacement - "{{SUNScholar}}" to "") |
|||
| Line 1: | Line 1: | ||
| − | + | ||
==PostgreSQL Database Credentials== | ==PostgreSQL Database Credentials== | ||
Revision as of 22:42, 29 December 2013
PostgreSQL Database Credentials
Create a credentials file for the postgres or dspace user. See:
- http://www.postgresql.org/docs/8.4/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
Press CTL+O and CTL+X to save and exit the file.
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
