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

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

1. Install the PostgreSQL server package:

   # yum install postgresql-server

   Copy to Clipboard Toggle word wrap
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/"
   # systemctl start postgresql.service
   # systemctl enable postgresql.service

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

   # su - postgres
   $ psql

   Copy to Clipboard Toggle word wrap
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 Toggle word wrap
5. Create a database in which to store data about the Red Hat 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 Toggle word wrap
6. Connect to the new database and add the plpgsql language:

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

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

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

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

    # systemctl restart postgresql.service

    Copy to Clipboard Toggle word wrap