Cloud CM-IPMP Guía para resolver problemas descargar pdf (Pagina 131)

Chapter 21

PostgreSQL Conﬁguration

21.1 Introduction

The Rhino SLEE requires a PostgreSQL RDBMS database for persisting the main working memory to non-volatile memory.

The main working memory in Rhino contains the runtime state, deployments, proﬁles, entities and the entities’ bindings.

Before installing a production Rhino cluster, PostgreSQL must be installed. For further information on downloading and

installing PostgreSQL platform refer to

http://www.postgresql.org

The PostgreSQL database can be installed on any network reachable host, although it is typically installed on the same local

host as Rhino SLEE.

Only a single PostgreSQL database is required for the entire Rhino SLEE cluster. The Rhino SLEE can replicate the main work-

ing memory across multiple PostgreSQL servers. For more information about using Rhino with multiple database backends,

please refer to Section 21.6.

The Rhino SLEE remains available whether or not the PostgreSQL database is available. The database does not affect or limit

how Rhino SLEE applications are written or operate. The PostgreSQL database provides a back-up of the working memory

only to restore a cluster if that cluster has entirely failed and needs to be restarted.

For Solaris/Sparc users, Open Cloud provides a pre-built PostgreSQL server package for Solaris. To install this package use the

Solaris

pkgadd

utility.

PostgreSQL is usually also available as a package on the various Linux distributions.

21.2 Installing PostgreSQL

PostgreSQL is usually packaged as part of your Linux distribution. Solaris users can make use of a pre-packaged PostgreSQL

package available at

http://www.blastwave.org

21.3 Creating Users

Once PostgreSQL has been installed, the next step is to create or assign a database user for the Rhino SLEE. This user will need

permissions to create databases, but does not need permissions to create users.

To create a new user for the database, use the “createuser” script supplied with PostgreSQL:

[postgres]$ createuser

Enter name of user to add: postgres

Shall the new user be allowed to create databases? (y/n) y

Shall the new user be allowed to create more new users? (y/n) n

CREATE USER

122

1 2 ... 126 127 128 129 130 131 132 133 134 135 136 ... 200 201

Sin comentarios

Cloud CM-IPMP Guía para resolver problemas Pagina 131