Chapter 2. Installation and Usage
This chapter contains information related to the installation and usage of Red Hat Software Collections 1.1.
2.1. Getting Access to Red Hat Software Collections
Depending on the subscription management service with which you registered your Red Hat Enterprise Linux system, you can either enable Red Hat Software Collections by using Red Hat Subscription Management, or by using RHN Classic. For detailed instructions on how to enable Red Hat Software Collections using RHN Classic or Red Hat Subscription Management, see the respective section below. For information on how to register your system with one of these subscription management services, see Using and Configuring Red Hat Subscription Manager.
Important
If you are running a version of Red Hat Enterprise Linux prior to 6.4, you will be unable to download Red Hat Software Collections through Red Hat Subscription Management. To obtain Red Hat Software Collections, either update to Red Hat Enterprise Linux 6.4, or register your system with RHN Classic. For more information, see https://access.redhat.com/site/solutions/129003.
2.1.1. Using Red Hat Subscription Management
If your system is registered with Red Hat Subscription Management, complete the following steps to attach the subscription that provides access to the repository for Red Hat Software Collections and enable the repository:
- Display a list of all subscriptions that are available for your system and determine the pool ID of a subscription that provides Red Hat Software Collections. To do so, type the following at a shell prompt as
root
:subscription-manager list --available
For each available subscription, this command displays its name, unique identifier, expiration date, and other details related to it. The pool ID is listed on a line beginning withPool Id
. - Attach the appropriate subscription to your system by running the following command as
root
:subscription-manager subscribe --pool=pool_id
Replace pool_id with the pool ID you determined in the previous step. To verify the list of subscriptions your system has currently attached, run asroot
:subscription-manager list --consumed
- Display the list of available Yum list repositories to retrieve repository metadata and determine the exact name of the Red Hat Software Collections repositories. As
root
, type:yum repolist all
The repository names depend on the specific version of Red Hat Enterprise Linux you are using and are in the following format:rhel-variant-rhscl-6-rpms rhel-variant-rhscl-6-debug-rpms rhel-variant-rhscl-6-source-rpms rhel-server-rhscl-6-eus-rpms rhel-server-rhscl-6-eus-source-rpms rhel-server-rhscl-6-eus-debug-rpms rhel-variant-rhscl-7-rpms rhel-variant-rhscl-7-debug-rpms rhel-variant-rhscl-7-source-rpms
Replace variant with the Red Hat Enterprise Linux system variant, that is,server
orworkstation
. Note that Red Hat Software Collections is supported neither on theClient
nor on theComputeNode
variant. - Enable the appropriate repository by running the following command as
root
:yum-config-manager --enable repository
Once the subscription is attached to the system, you can install Red Hat Software Collections as described in Section 2.2, “Installing Red Hat Software Collections”. For more information on how to register your system using Red Hat Subscription Management and associate it with subscriptions, see Using and Configuring Red Hat Subscription Manager.
2.1.2. Using RHN Classic
If your system is registered with RHN Classic (applicable to Red Hat Enterprise Linux versions prior to 6.4), complete the following steps to subscribe to Red Hat Software Collections:
- Display a list of all channels that are available to you and determine the exact name of the Red Hat Software Collections channel. To do so, type the following at a shell prompt as
root
:rhn-channel --available-channels
The name of the channel depends on the specific version of Red Hat Enterprise Linux you are using and is in the following format, where variant is the Red Hat Enterprise Linux system variant (server
orworkstation
):rhel-x86_64-variant-6-rhscl-1 rhel-x86_64-server-6.3.z-rhscl-1 rhel-x86_64-server-6.4.z-rhscl-1 rhel-x86_64-server-6.5.z-rhscl-1 rhel-x86_64-variant-7-rhscl-1
Note that Red Hat Enterprise Linux 7 channels are accessible only through Red Hat Satellite instances. - Subscribe the system to the Red Hat Software Collections channel by running the following command as
root
:rhn-channel --add --channel=channel_name
Replace channel_name with the name you determined in the previous step. - Verify the list of channels you are subscribed to. As
root
, type:rhn-channel --list
Once the system is subscribed, you can install Red Hat Software Collections as described in Section 2.2, “Installing Red Hat Software Collections”. For more information on how to register your system with RHN Classic, see Using and Configuring Red Hat Subscription Manager.
2.2. Installing Red Hat Software Collections
Red Hat Software Collections is distributed as a collection of RPM packages that can be installed, updated, and uninstalled by using the standard package management tools included in Red Hat Enterprise Linux. Note that a valid subscription is required to install Red Hat Software Collections on your system. For detailed instructions on how to associate your system with an appropriate subscription and get access to Red Hat Software Collections, see Section 2.1, “Getting Access to Red Hat Software Collections”.
Important
Some of the Red Hat Software Collections 1.1 packages require the
Optional
channel to be enabled in order to complete the full installation of these packages:
- The php54-php-imap and php55-php-imap packages require the libc-client package from the Optional channel.
- The php54-php-recode and php55-php-recode packages require the recode package from the Optional channel.
- The perl516-perl-devel package requires the gdbm-devel package from the Optional channel.
- The mariadb55-mariadb-bench package requires the perl-GD package from the Optional channel.
In Red Hat Enterprise Linux 7, the following packages available only in the
Optional
channel are required:
- The Node.js Software Collection depends on the nodejs010-nodejs-devel package, which requires the c-ares-devel package from the Optional channel (applicable to minimal install).
- The httpd24-mod_ldap package requires the apr-util-ldap package from the Optional channel.
- The php54-php-pspell and php55-php-pspell packages require the aspell package from the Optional channel.
- The python27-python-debug package requires the tix package from the Optional channel.
- The thermostat1-thermostat package requires the apache-commons-beanutils, jansi, hawtjni, jansi-native, and objectweb-asm packages from the Optional channel (applicable to minimal install).
- The thermostat1-thermostat-webapp package requires the felix-framework package from the Optional channel (applicable to minimal install).
- The thermostat1-netty package requires the jzlib package from the Optional channel (applicable to minimal install).
- The apache-commons-logging package requires the xerces-j2 package from the Optional channel (applicable to minimal install).
For detailed instructions on how to subscribe your system to this channel, see the relevant Knowledgebase article on the Customer Portal.
Important
Use of Red Hat Software Collections 1.1 requires the removal of the pre-release versions. It is not possible to update to any Red Hat Software Collections 1.1 component from the Beta version. If you have previously installed any Red Hat Software Collections 1.1 component from the Beta version of Red Hat Software Collections, uninstall it from your system and install the new version as described in the Section 2.3, “Uninstalling Red Hat Software Collections” and Section 2.2.1, “Installing Individual Software Collections” sections.
Important
The in-place upgrade from Red Hat Enterprise Linux 6 to Red Hat Enterprise Linux 7 is not supported by Red Hat Software Collections. As a consequence, the installed Software Collections might not work correctly after the upgrade. If you want to upgrade from Red Hat Enterprise Linux 6 to Red Hat Enterprise Linux 7, it is strongly recommended to remove all Red Hat Software Collections packages, perform the in-place upgrade, update the Red Hat Software Collections repository, and install the Software Collections packages again. It is advisable to back up all data before upgrading.
2.2.1. Installing Individual Software Collections
To install any of the Software Collections that are listed in Table 1.1, “Red Hat Software Collections 1.1 Components”, install the corresponding meta package by typing the following at a shell prompt as
root
:
yum install software_collection...
Replace software_collection with a space-separated list of Software Collections you want to install. For example, to install php54 and mariadb55, type as
root
:
~]# yum install php54 mariadb55
This installs the main meta package for the selected Software Collection and a set of required packages as its dependencies. For information on how to install additional packages such as additional modules, see Section 2.2.2, “Installing Optional Packages”.
2.2.2. Installing Optional Packages
Each component of Red Hat Software Collections is distributed with a number of optional packages that are not installed by default. To list all packages that are part of a certain Software Collection but are not installed on your system, type the following at a shell prompt:
yum list available software_collection-\*
To install any of these optional packages, run as
root
:
yum install package_name...
Replace package_name with a space-separated list of packages that you want to install. For example, to install the perl516-perl-CPAN and perl516-perl-Archive-Tar, type:
~]# yum install perl516-perl-CPAN perl516-perl-Archive-Tar
2.2.3. Installing Debugging Information
To install debugging information for any of the Red Hat Software Collections packages, make sure that the yum-utils package is installed and run the following command as
root
:
debuginfo-install package_name
For example, to install debugging information for the ruby193-ruby package, type:
~]# debuginfo-install ruby193-ruby
Note that in order to use this command, you need to have access to the repository with these packages. If your system is registered with Red Hat Subscription Management, enable the
rhel-variant-rhscl-6-debug-rpms
repository as described in Section 2.1.1, “Using Red Hat Subscription Management”. If your system is registered with RHN Classic, subscribe the system to the rhel-x86_64-variant-6-rhscl-1-debuginfo
channel as described in Section 2.1.2, “Using RHN Classic”. For more information on how to get access to debuginfo packages, see https://access.redhat.com/site/solutions/9907.
2.3. Uninstalling Red Hat Software Collections
To uninstall any of the Software Collections components, type the following at a shell prompt as
root
:
yum remove software_collection\*
Replace software_collection with the Software Collection component you want to uninstall.
Note that uninstallation of the packages provided by Red Hat Software Collections does not affect the Red Hat Enterprise Linux system versions of these tools.
2.4. Rebuilding Red Hat Software Collections
<collection>-build packages are not provided by default. If you wish to rebuild a collection and do not want or cannot use the
rpmbuild --define 'scl foo'
command, you first need to rebuild the metapackage, which provides the <collection>-build package.
Note that existing collections should not be rebuilt with different content. To add new packages into an existing collection, you need to create a new collection containing the new packages and make it dependent on packages from the original collection. The original collection has to be used without changes.
For detailed information on building Software Collections, refer to the Red Hat Developer Toolset Software Collections Guide.
2.5. Using Red Hat Software Collections
2.5.1. Running an Executable from a Software Collection
To run an executable from a particular Software Collection, type the following command at a shell prompt:
scl enable software_collection... 'command...'
Or, alternatively, use the following command:
scl enable software_collection... -- command...
Replace software_collection with a space-separated list of Software Collections you want to use and command with the command you want to run. For example, to execute a Perl program stored in a file named
hello.pl
with the Perl interpreter from the perl516 Software Collection, type:
~]$ scl enable perl516 'perl hello.pl'
Hello, World!
You can execute any command using the
scl
utility, causing it to be run with the executables from a selected Software Collection in preference to their possible Red Hat Enterprise Linux system equivalents. For a complete list of Software Collections that are distributed with Red Hat Software Collections, see Table 1.1, “Red Hat Software Collections 1.1 Components”.
2.5.2. Running a Shell Session with a Software Collection as Default
To start a new shell session with executables from a selected Software Collection in preference to their Red Hat Enterprise Linux equivalents, type the following at a shell prompt:
scl enable software_collection... bash
Replace software_collection with a space-separated list of Software Collections you want to use. For example, to start a new shell session with the python27 and postgresql92 Software Collections as default, type:
~]$ scl enable python27 postgresql92 bash
The list of Software Collections that are enabled in the current session is stored in the
$X_SCLS
environment variable, for instance:
~]$ echo $X_SCLS
python27 postgresql92
For a complete list of Software Collections that are distributed with Red Hat Software Collections, see Table 1.1, “Red Hat Software Collections 1.1 Components”.
2.5.3. Running a System Service from a Software Collection
Software Collections that include system services install corresponding init scripts in the
/etc/rc.d/init.d/
directory. To start such a service in the current session, type the following at a shell prompt as root
:
service software_collection-service_name start
Replace software_collection with the name of the Software Collection and service_name with the name of the service you want to start. To configure this service to start automatically at boot time, run the following command as
root
:
chkconfig software_collection-service_name on
For example, to start the
postgresql
service from the postgresql92 Software Collection and enable it in runlevels 2, 3, 4, and 5, type as root
:
~]#service postgresql92-postgresql start
Starting postgresql92-postgresql service: [ OK ] ~]#chkconfig postgresql92-postgresql on
For more information on how to manage system services in Red Hat Enterprise Linux 6, refer to the Red Hat Enterprise Linux 6 Deployment Guide. For a complete list of Software Collections that are distributed with Red Hat Software Collections, see Table 1.1, “Red Hat Software Collections 1.1 Components”.
2.6. Accessing a Manual Page from a Software Collection
Every Software Collection contains a general manual page that describes the content of this component. Each manual page has the same name as the component and it is located in the
/opt/rh
directory.
To read a manual page for a Software Collection, run the following command:
scl enable software_collection 'man software_collection'
Replace software_collection with the particular Red Hat Software Collections component. For example, to display the manual page for mariadb55, type:
~]$ scl enable mariadb55 "man mariadb55"
2.7. Deploying Applications That Use Red Hat Software Collections
In general, you can use one of the following two approaches to deploy an application that depends on a component from Red Hat Software Collections in production:
- Install all required Software Collections and packages manually and then deploy your application, or
- Create a new Software Collection for your application and specify all required Software Collections and other packages as dependencies.
For more information on how to manually install individual Red Hat Software Collections components, see Section 2.2, “Installing Red Hat Software Collections”. For further details on how to use Red Hat Software Collections, see Section 2.5, “Using Red Hat Software Collections”. For a detailed explanation of how to create a custom Software Collection or extend an existing one, read the Red Hat Developer Toolset Software Collections Guide.
2.8. Migrating from MySQL 5.1 to MySQL 5.5
2.8.1. Notable Differences Between MySQL 5.1 and MySQL 5.5
The following is a list of the most important changes between MySQL 5.1 and MySQL 5.5
- Starting with MySQL 5.5, the InnoDB storage engine (formerly known as InnoDB Plugin) is the default storage engine.
- InnoDB and some other plug-ins (for example, archive, blackhole and federated) were installable plug-ins in MySQL 5.1. Starting with MySQL 5.5, these plug-ins became compiled-in storage engines, that is, they cannot be installed or uninstalled by default.
- If you used InnoDB Plugin and it was loaded using the
plugin-load=innodb=ha_innodb_plugin.so
configuration option, you need to remove this configuration option as it does not work in MySQL 5.5. - In MySQL 5.1, InnoDB Plugin included a configuration variable
innodb_file_io_threads
. However, this variable does not exist in MySQL 5.5; new variables,innodb_read_io_threads
andinnodb_write_io_threads
, are used instead. To ensure proper functionality, either remove the former variable from the configuration file or replace it with the current variables. - When upgrading from MySQL 5.1 to MySQL 5.5 using the in-place upgrading method, the
mysql.proxies_priv
table will not exist. To create the missing table, the mysql_upgrade utility has to be run as soon as the new daemon is started. - MySQL 5.5 uses latin1 for the
stopword
file if thecharacter_set_server
variable is ucs2, utf16 or utf32. Thus, if the table uses FULLTEXT indexes in these cases, users should repair the table using theREPAIR TABLE table_name QUICK
. - MySQL 5.1 used the
language
variable for specifying the directory which included the error message file. This option is now deprecated and has been replaced by thelc_messages_dir
andlc_messages
options. This also applies for configuration options. Also, error messages no longer contain mixed set of character sets and error messages are returned in the set following thecharacter_set_results
system variable instead. That is, some error messages can be different in MySQL 5.5.
Please note that the EXAMPLE plug-in is no longer distributed in Red Hat Software Collections packages.
For more information about MySQL 5.1 and MySQL 5.5, refer to the release notes available at http://dev.mysql.com/doc/relnotes/mysql/5.1/en/ and http://dev.mysql.com/doc/relnotes/mysql/5.5/en/.
Important
MariaDB is a community-developed drop-in replacement for MySQL. The differences between MySQL 5.1 and MySQL 5.5 are valid also for MySQL 5.1 and MariaDB 5.5.
2.8.2. Upgrading from MySQL 5.1 to MySQL 5.5
Before migrating from MySQL 5.1 to MySQL 5.5, back up all your data, including any MySQL databases. Because the mysql55 Software Collection does not conflict with the mysql packages from the core systems, it is possible to install the mysql55 Software Collection together with the mysql packages. It is also possible to run both versions at the same time, however, the port number and the socket in the my.cnf files need to be changed to prevent these specific resources from conflicting.
Upgrading can be performed either by using the mysqldump and mysqlimport utilities or using in-place upgrade:
- In the first scenario, the whole dump of all databases from one database is generated, mysql is run with the dump file as an input, using mysqlimport or the
LOAD DATA INFILE
SQL command within the other database. At the same time, the appropriate daemons have to be running during both dumping and restoring. You can use the--all-databases
option in the mysqldump call to include all databases in the dump. The--routines
,--triggers
and--events
options can also be used if needed. - During the in-place upgrade, the data files are copied from one database directory to another database directory. The daemons should not be running at the time of copying. Set the appropriate permissions and SELinux context for copied files.
After upgrading, start the server and run the
mysql_upgrade
command. Running mysql_upgrade
is necessary to check and repair internal tables.
Important
All scripts that work with a server form Software Collection, especially the
mysql_upgrade
script, should be run inside the scl enable
environment.
In case the
root
user has a non-empty password defined (it should have it defined), it is necessary to call the mysql_upgrade utility with the -p
option and specify the password.
The dump and restore upgrade method is recommended. The in-place upgrade method is usually faster, however, there are certain risks and known problems. For more information, refer to the MySQL 5.5 Release Notes.
In addition, once the upgrade is complete, consider changing the appropriate settings in the
my.cnf
file to reflect the environment.
Example 2.1. Dump and Restore Upgrade
~]#service mysqld start
Starting mysqld: [ OK ] ~]#mysqldump --all-databases --routines --events > dump.sql
~]#service mysqld stop
Stopping mysqld: [ OK ] ~]#service mysql55-mysqld start
Starting mysql55-mysqld: [ OK ] ~]#scl enable mysql55 'mysql' < dump.sql
~]#scl enable mysql55 'mysql_upgrade -u root -p'
Enter password: Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck with default connection arguments Running 'mysqlcheck with default connection arguments a.t1 OK mysql.columns_priv OK <skipped tables list> mysql.user OK Running 'mysql_fix_privilege_tables'... OK
Example 2.2. In-place Upgrade
~]#service mysqld stop
Stopping mysqld: [ OK ] ~]#service mysql55-mysqld stop
Stopping mysql55-mysqld: [ OK ] ~]#rm -rf /opt/rh/mysql55/root/var/lib/mysql/
~]#cp -r /var/lib/mysql/ /opt/rh/mysql55/root/var/lib/
~]#chown -R mysql:mysql /opt/rh/mysql55/root/var/lib/mysql/
~]#restorecon -R /opt/rh/mysql55/root/var/lib/mysql/
~]#service mysql55-mysqld start
Starting mysql55-mysqld: [ OK ] ~]#scl enable mysql55 'mysql_upgrade -u root -p'
Enter password: Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck with default connection arguments Running 'mysqlcheck with default connection arguments a.t1 OK mysql.columns_priv OK <skipped tables list> mysql.user OK Running 'mysql_fix_privilege_tables'... OK
For more information about the upgrading process, refer to MySQL 5.5 Reference Manual.
Important
MariaDB is a community-developed drop-in replacement for MySQL. The steps for upgrading from MySQL 5.1 to MySQL 5.5 are valid also for upgrading from MySQL 5.1 to MariaDB 5.5, with the exception of the following differences:
- The mariadb55 component name should be used instead of the mysql55, so replace all occurrences of
mysql55
withmariadb55
. - The
systemd
unit name for MariaDB 5.5. ismariadb55-mariadb
in Red Hat Enterprise Linux 7, while theSysV
unit script for MariaDB 5.5 is calledmariadb55-mysqld
in Red Hat Enterprise Linux 6.
2.8.3. Using the mysql55-mysql-devel Package
Red Hat Software Collections contains the server part of MySQL 5.5 database. Red Hat Enterprise Linux 6 provides version 5.1 of this database (client library and server daemon). A protocol which is used between the client library and the daemon is stable across database versions, so using, for example, the MySQL 5.1 client library with the MySQL 5.5 daemon works as expected.
2.8.3.1. Using Database Connectors for Dynamic Languages
Important
When a MariaDB or MySQL database contains old users created using old authentication schema, PHP using the
mysqlnd
driver will not be able to connect to the database. This is because the old_password
setting in the /etc/my.cnf
file is turned off by default on Red Hat Enterprise Linux 6 while it is enabled on Red Hat Enterprise Linux 5. To work around this problem, set old_password
to 0, restart the MariaDB or MySQL service and set a new password for each user.
2.8.3.2. Building Applications for MySQL 5.5 from Red Hat Software Collections
MySQL 5.5 from Red Hat Software Collections does not include database connectors; client libraries packaged in the MySQL 5.5 Red Hat Software Collections database packages are not supposed to be used as they are included only for purposes of server utilities and the daemon. Users are instead expected to use the system libraries and database connectors provided with the core system.
It means that users who would like to link their application against the MySQL client library should compile it and link it to the core Red Hat Enterprise Linux 6 environment, not to the MySQL 5.5 Red Hat Software Collections environment.
The only exception to this are server-side plug-ins, which are expected to be built under the MySQL 5.5 Red Hat Software Collections environment. This means the build process should be run inside the
scl enable mysql55 '...'
call.
2.9. Migrating from PostgreSQL 8.4 to PostgreSQL 9.2
Red Hat Software Collections 1.1 is distributed with PostgreSQL 9.2, which can be safely installed on the same machine in parallel with PostgreSQL 8.4 from Red Hat Enterprise Linux 6. It is also possible to run both versions of PostgreSQL on one machine at the same time, but you need to use different ports or IP addresses and adjust SELinux policy.
2.9.1. Notable Differences Between PostgreSQL 8.4 and PostgreSQL 9.2
The following is a list of the most important changes between PostgreSQL 8.4 and PostgreSQL 9.2:
- The following server configuration parameters have been removed and are no longer supported:
add_missing_from
,regex_flavor
,silent_mode
,wal_sender_delay
, andcustom_variable_classes
. Do not use any of these parameters in the new configuration file. - The
unix_socket_directory
parameter has been renamed tounix_socket_directories
and can now be used to specify more than one UNIX socket to listen on. To do so, provide a list of comma-separated directories as the value of this option. The default value remains unchanged and is/tmp
. - New configuration parameters
ssl_ca_file
,ssl_cert_file
,ssl_crl_file
, andssl_key_file
have been added. These configuration parameters can be used to specify the locations of server-side SSL files that were previously hard-coded as relative paths to theroot.crt
,server.crt
,root.crl
, andserver.key
files in the data directory.Note that the PostgreSQL server no longer reads theroot.crt
androot.crl
files by default. To load these files, change the corresponding parameters to non-default values. - The
=>
operator has been removed and users are now advised to use thehstore(text, text)
function. - The default value of the
standard_conforming_strings
configuration parameter is nowon
. This configuration parameter controls if ordinary string literals (strings enclosed in single quotes) treat backslashes literally as specified in the SQL standard. - A new configuration parameter,
backslash_quote
, has been added. This configuration parameter can be used to control whether a single quotation mark can be represented by\'
in string literals. The default value issafe_encoding
, which permits the use of\'
only when the client encoding does not allow ASCII backslashes in multi-byte characters. As a consequence,\'
can now be interpreted differently only in specific cases and only in string literals that do not conform to standards, including escape string syntax,E'value'
. - PostgreSQL 9.0 introduced access privileges for large objects. Consequently, a new configuration parameter,
lo_compat_privileges
, has been added to allow you to disable security checks related to the large objects affected by this change. To disable these security checks, change the value of this configuration parameter toon
. The default value isoff
.
For a detailed list of known compatibility issues with earlier versions, see the official notes for PostgreSQL 9.0, PostgreSQL 9.1, and PostgreSQL 9.2. For an in-depth list of changes in behavior, see the upstream Release Notes.
2.9.2. Upgrading from PostgreSQL 8.4 to PostgreSQL 9.2
To migrate your data from PostgreSQL 8.4 that is distributed with Red Hat Enterprise Linux 6 to PostgreSQL 9.2 that is included in Red Hat Software Collections 1.1, you can either perform an in-place upgrade (recommended), or dump the database data into a text file with SQL commands and import it in the new database. Note that the second method is usually significantly slower and may require manual fixes; see the official documentation for more information about this upgrade method. If you need to migrate PosgreSQL databases to Red Hat Enterprise Linux 7, see https://access.redhat.com/site/articles/541873 and https://access.redhat.com/site/articles/694413.
Important
Before migrating your data from PostgreSQL 8.4 to PostgreSQL 9.2, make sure that you back up all your data, including the PostgreSQL database files that are by default located in the
/var/lib/pgsql/data/
directory.
Procedure 2.1. Performing In-place Upgrade
To perform an in-place upgrade of your PostgreSQL server, complete the following steps:
- Stop the old PostgreSQL server to ensure that the data is not in an inconsistent state. To do so, type the following at a shell prompt as
root
:service postgresql stop
To verify that the server is not running, type:service postgresql status
- Verify that the new data directory located in
/opt/rh/postgresql92/root/var/lib/pgsql/data/
does not exist:file /opt/rh/postgresql92/root/var/lib/pgsql/data/
If you are running a fresh installation of PostgreSQL 9.2, this directory should not be present in your system. If it is, back it up by running the following command asroot
:mv /opt/rh/postgresql92/root/var/lib/pgsql/data{,-scl-backup}
- Copy the old database data to the new location by typing the following at a shell prompt as
root
:cp -ra /var/lib/pgsql/data/ /opt/rh/postgresql92/root/var/lib/pgsql/
- Open the
/opt/rh/postgresql92/root/var/lib/pgsql/data/pg_hba.conf
configuration file and verify that thepostgres
user is allowed to connect to the PostgreSQL server fromlocalhost
without a password. If not, you can edit this file and temporarily set the authentication method for thepostgres
user totrust
orident
. For a detailed description of thepg_hba.conf
file and a complete list of available configuration options, see the official documentation. - Upgrade the database data for the new server by running the following command as
root
:service postgresql92-postgresql upgrade
It is recommended that you read the resulting/opt/rh/postgresql92/root/var/lib/pgsql/pgupgrade.log
log file to see if there were any problems with the upgrade. - Start the new server as
root
:service postgresql92-postgresql start
It is also advised that you run theanalyze_new_cluster.sh
script as follows:su - postgres -c 'scl enable postgresql92 ~/analyze_new_cluster.sh'
- Optionally, you can configure the PostgreSQL 9.2 server to start automatically at boot time. To disable the old PostgreSQL 8.4 server, run the following command as
root
:chkconfig postgresql off
To enable the PostgreSQL 9.2 server, type asroot
:chkconfig postgresql92-postgresql on
Procedure 2.2. Performing a Dump and Restore Upgrade
To perform a dump and restore upgrade of your PostgreSQL server, complete the following steps:
- Ensure that the old PostgreSQL server is running by typing the following at a shell prompt as
root
:service postgresql start
- Dump all data in the PostgreSQL database into a script file. As
root
, type:su - postgres -c 'pg_dumpall > ~/pgdump_file.sql'
- Stop the old server by running the following command as
root
:service postgresql stop
- Initialize the data directory for the new server as
root
:service postgresql92-postgresql initdb
- Start the new server as
root
:service postgresql92-postgresql start
- Import data from the previously created SQL file:
su - postgres -c 'scl enable postgresql92 "psql -f ~/pgdump_file.sql postgres"'
- Optionally, you can configure the PostgreSQL 9.2 server to start automatically at boot time. To disable the old PostgreSQL 8.4 server, run the following command as
root
:chkconfig postgresql off
To enable the PostgreSQL 9.2 server, type asroot
:chkconfig postgresql92-postgresql on
- If your configuration differs from the default one, make sure to update configuration files, especially the
/opt/rh/postgresql92/root/var/lib/pgsql/data/pg_hba.conf
configuration file. Otherwise only thepostgres
user will be allowed to access the database.
2.10. Reporting Bugs in Red Hat Software Collections
Bug reports are essential in making Red Hat Software Collections reliable. Reporting a bug can also help you bring a solution to your problem. Nevertheless, the main function of a bug report is to help the community by improving the next version of Red Hat Software Collections.
To report a bug in Red Hat Software Collections, complete the following steps:
- Navigate to Bugzilla, the Red Hat bug-tracking system. Note that you need to be logged in, or you will be prompted to do so.
- On the top bar, click onand on the next page, choose . This brings you to a page with a list of Red Hat Products.
- Click on form., which brings you to this
- Fill in the relevant fields.
RHSCL-1-software_collection
- Optionally, you can add an attachment, which can be a screenshot of the problem, a patch, or similar.
- Once you have completed your bug report, press thebutton. Your report will be assigned a Bugzilla number so you can get back to it later.
If you wish to use the Automatic Bug Reporting Tool (ABRT) utility, see the Red Hat Enterprise Linux 6 Deployment Guide or Red Hat Enterprise Linux 7 System Administrator's Guide. For detailed information on bug reporting, refer to Bugzilla's help.