Difference between revisions of "SUNScholar/Disaster Recovery/Preparation"
Jump to navigation
Jump to search
(Created page with "==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://ww...") |
|||
| Line 10: | Line 10: | ||
To create the credential file type. | To create the credential file type. | ||
| − | + | nano ~/.pgpass | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
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 | ||
Press '''CTL+O''' and '''CTL+X''' to save and exit the file. | Press '''CTL+O''' and '''CTL+X''' to save and exit the file. | ||
| + | |||
| + | To lock down file permissions type. | ||
| + | chmod 0600 ~/.pgpass | ||
To test type. | To test type. | ||
Revision as of 16:24, 23 August 2012
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
