SUNScholar/Disaster Recovery/Preparation - Revision history

Hgibson at 09:18, 28 May 2016

2016-05-28T09:18:45Z

2014-04-04T07:34:35Z

PostgreSQL Database Credentials

2014-04-04T07:33:59Z

2014-03-06T02:58:40Z

2014-03-06T02:57:53Z

2014-03-06T02:56:27Z

2014-03-06T02:55:00Z

2013-12-29T20:42:44Z

Text replacement - "{{SUNScholar}}" to ""

2013-05-07T08:02:11Z

2012-08-23T14:24:10Z

PostgreSQL Database Credentials

← Older revision		Revision as of 09:18, 28 May 2016
Line 32:		Line 32:
	To quit the database type.		To quit the database type.
	'''\q'''		'''\q'''
		+	[[Category:System Administration]]

@@ Line 28: / Line 28: @@
   psql
-You should be connected to the database now.
+You should be automatically connected to the database now.
 To quit the database type.
   '''\q'''

@@ Line 1: / Line 1: @@
 <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]]'''
 </center>

@@ Line 18: / Line 18: @@
 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''
+This file should contain lines of the following format: '''''hostname:port:database:username:password'''''
 To lock down file permissions type.

@@ Line 18: / Line 18: @@
 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.
+This file should contain lines of the following format: ''hostname:port:database:username:password''
 To lock down file permissions type.

@@ Line 6: / Line 6: @@
 Create a credentials file for the postgres or dspace user.
 See:
-* http://www.postgresql.org/docs/8.4/interactive/libpq-pgpass.html
+* 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:

← Older revision		Revision as of 02:55, 6 March 2014
Line 1:		Line 1:
−		+	<center>
		+	'''[[SUNScholar/Disaster Recovery/System Monitor/Client\|Back to Disaster Recovery System Monitor Client]]'''
		+	</center>

	==PostgreSQL Database Credentials==		==PostgreSQL Database Credentials==

← Older revision		Revision as of 20:42, 29 December 2013
Line 1:		Line 1:
−	~~{{SUNScholar}}~~	+

	==PostgreSQL Database Credentials==		==PostgreSQL Database Credentials==

← Older revision		Revision as of 08:02, 7 May 2013
Line 1:		Line 1:
		+	{{SUNScholar}}
		+
	==PostgreSQL Database Credentials==		==PostgreSQL Database Credentials==
	Create a credentials file for the postgres or dspace user.		Create a credentials file for the postgres or dspace user.

@@ Line 10: / Line 10: @@
 To create the credential file type.
- touch ~/.pgpass
+  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 test type.