Changes

===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====

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====

  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===

  /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====

TBA

TBA

[[Category:Software Collections]]

[[Category:Software Collections]]