Appendix D. Preparing a Remote PostgreSQL Database for Use with the Red Hat Enterprise Virtualization Manager

Procedure D.1. Preparing a Remote PostgreSQL Database for use with the Red Hat Enterprise Virtualization Manager

1. Install the PostgreSQL server package:

   # yum install postgresql-server

2. Initialize the PostgreSQL database, start the postgresql service, and ensure that this service starts on boot:

   # su -l postgres -c "/usr/bin/initdb --locale=en_US.UTF8 --auth='ident' --pgdata=/var/lib/pgsql/data/"
   # service postgresql start
   # chkconfig postgresql on

3. Connect to the psql command line interface as the postgres user:

   # su - postgres
   $ psql

4. Create a user for the Manager to use when it writes to and reads from the database. The default user name on the Manager is engine:

   postgres=# create role user_name with login encrypted password 'password';

5. Create a database in which to store data about the Red Hat Enterprise Virtualization environment. The default database name on the Manager is engine:

   postgres=# create database database_name owner user_name template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';
   

6. Connect to the new database and add the plpgsql language:

   postgres=# \c database_name
   database_name=# CREATE LANGUAGE plpgsql;

7. Ensure the database can be accessed remotely by enabling md5 client authentication. Edit the /var/lib/pgsql/data/pg_hba.conf file, and add the following line immediately underneath the line starting with local at the bottom of the file, replacing X.X.X.X with the IP address of the Manager:

   host    database_name    user_name    X.X.X.X/32   md5

8. Allow TCP/IP connections to the database. Edit the /var/lib/pgsql/data/postgresql.conf file and add the following line:

   listen_addresses='*'

   This example configures the postgresql service to listen for connections on all interfaces. You can specify an interface by giving its IP address.
9. Open the default port used for PostgreSQL database connections, and save the updated firewall rules:

   # iptables -I INPUT 5 -p tcp --dport 5432 -j ACCEPT
   # service iptables save

10. Restart the postgresql service:

    # service postgresql restart