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:
   Copy to Clipboard Toggle word wrap

   # yum install postgresql-server

2. Initialize the PostgreSQL database, start the postgresql service, and ensure that this service starts on boot:
   Copy to Clipboard Toggle word wrap

   # 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:
   Copy to Clipboard Toggle word wrap

   # 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:
   Copy to Clipboard Toggle word wrap

   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:
   Copy to Clipboard Toggle word wrap

   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:
   Copy to Clipboard Toggle word wrap

   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:
   Copy to Clipboard Toggle word wrap

   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:
   Copy to Clipboard Toggle word wrap

   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:
   Copy to Clipboard Toggle word wrap

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

10. Restart the postgresql service:
    Copy to Clipboard Toggle word wrap

    # service postgresql restart