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

   Copy to Clipboard
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

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

   # su - postgres
   $ psql

   Copy to Clipboard
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';

   Copy to Clipboard
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';
   

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

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

   Copy to Clipboard
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

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

   listen_addresses='*'

   Copy to Clipboard
   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

   Copy to Clipboard
10. Restart the postgresql service:

    # service postgresql restart

    Copy to Clipboard