Changes

From SME Server
Jump to navigationJump to search

Software Collections:PostgreSQL (view source)

Revision as of 17:05, 6 January 2015

13 bytes removed ,  17:05, 6 January 2015
no edit summary
Line 10: Line 10:     
Software Collections applications can be started at boot as a system service, manually or in a specific shell.
 
Software Collections applications can be started at boot as a system service, manually or in a specific shell.
−
      
==PostgreSQL==
 
==PostgreSQL==
 
===Installation===
 
===Installation===
 
To be able to install an application from the Software Collections, one '''must''' install software collections first. Please see [[Software collections]] on how to install this.
 
To be able to install an application from the Software Collections, one '''must''' install software collections first. Please see [[Software collections]] on how to install this.
−
      
====Required repository====
 
====Required repository====
 
After installing Software Collections, the [http://wiki.contribs.org/Scl#tab=PostgreSQL92 '''scl'''] repository for PostgreSQL has to added to the yum repositories. Please see [http://wiki.contribs.org/Scl#tab=PostgreSQL92 '''here'''] on how the enable the [http://wiki.contribs.org/Scl#tab=PostgreSQL92 '''scl-postgresql92'''] repository.
 
After installing Software Collections, the [http://wiki.contribs.org/Scl#tab=PostgreSQL92 '''scl'''] repository for PostgreSQL has to added to the yum repositories. Please see [http://wiki.contribs.org/Scl#tab=PostgreSQL92 '''here'''] on how the enable the [http://wiki.contribs.org/Scl#tab=PostgreSQL92 '''scl-postgresql92'''] repository.
−
  −
  −
      
====Install application====
 
====Install application====
Line 29: Line 24:     
Only '''1''' service script has been installed on your base SME Server in /etc/rc.d/init.d/ which is '''postgresql92-postgresql'''. This script will start and stop the installed application.
 
Only '''1''' service script has been installed on your base SME Server in /etc/rc.d/init.d/ which is '''postgresql92-postgresql'''. This script will start and stop the installed application.
−
  −
  −
      
====Test installed application====
 
====Test installed application====
Line 41: Line 33:  
  scl enable postgresql92 'man postgresql92'
 
  scl enable postgresql92 'man postgresql92'
 
press 'q' to leave the man page
 
press 'q' to leave the man page
−
      
====Initialize database====
 
====Initialize database====
 
PostgreSQL requires the initialization of t's database environment. This can be done by the following command:
 
PostgreSQL requires the initialization of t's database environment. This can be done by the following command:
 
  service postgresql92-postgresql initdb
 
  service postgresql92-postgresql initdb
−
      
===Start/Stop the application===
 
===Start/Stop the application===
Line 53: Line 43:  
and
 
and
 
  /etc/rc.d/init.d/postgresql92-postgres start
 
  /etc/rc.d/init.d/postgresql92-postgres start
−
  −
  −
      
====Start/Stop PostgreSQL as a system Service====
 
====Start/Stop PostgreSQL as a system Service====
Retrieved from "https://wiki.koozali.org/Special:MobileDiff/26924"

Navigation menu