-
Language:
English
-
Language:
English
Red Hat Training
A Red Hat training course is available for Red Hat Satellite
2.3.3. External Database Requirements
The External Database version of Red Hat Satellite requires additional hardware considerations. This section specifies these requirements when installing the Red Hat Satellite server and connecting to an external database.
Red Hat supports Red Hat Satellite installations on a External Database using one of the following:
- PostgreSQL 8.4 or greater
- Oracle Database 11g Standard and Enterprise Edition
- Oracle Database 10g Release 2 Standard and Enterprise Edition
Ensure the External Database runs on a different server to the Red Hat Satellite.
Important
The following database migrations are not supported:
- PostgreSQL Databases to Oracle Databases
- PostgreSQL Embedded Database to PostgreSQL External Database
- PostgreSQL External Database to PostgreSQL Embedded Database
2.3.3.1. PostgreSQL Database Requirements
If running a PostgreSQL External Database, install the
postgresql-pltcl
package to your system. This package contains the PL/Tcl procedural language for PostgreSQL, which Satellite's audit logging features require. To install this package, log in to your External Database server and run the following command:
# yum install postgresql-pltcl
Note
If running a PostgreSQL External Database on Red Hat Enterprise Linux 5, use the
postgresql84-pltcl
package.
PostgreSQL requires some tuning to provide the optimal performance of your Red Hat Satellite server. For manual tuning of your
/var/lib/pgsql/data/postgresql.conf
, set the following parameters:
#shared_buffers = 24MB maintenance_work_mem = 224MB checkpoint_completion_target = 0.7 effective_cache_size = 2560MB work_mem = 6MB wal_buffers = 4MB checkpoint_segments = 8 shared_buffers = 896MB max_connections = 600 listen_addresses = '*' bytea_output = 'escape'
Note
The
bytea_output
parameter sets the correct encoding for bytea datatypes. Without this parameter, Satellite's Taskomatic service fails.
Restart the PostgreSQL server for these changes to take effect:
# service postgresql92-postgresql restart