Difference between revisions of "SUNScholar/Disaster Recovery/Preparation"
Jump to navigation
Jump to search
m |
m |
||
| Line 6: | Line 6: | ||
Create a credentials file for the postgres or dspace user. | Create a credentials file for the postgres or dspace user. | ||
See: | See: | ||
| − | * http://www.postgresql.org/docs/ | + | * http://www.postgresql.org/docs/9.1/interactive/libpq-pgpass.html |
* http://www.pgadmin.org/docs/1.4/pg/libpq-pgpass.html | * http://www.pgadmin.org/docs/1.4/pg/libpq-pgpass.html | ||
Open a terminal on the server and type the following: | Open a terminal on the server and type the following: | ||
Revision as of 04:56, 6 March 2014
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
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
