Chapter 4. System requirements

Procedure

1. Install and then connect to a PostgreSQL compliant database server with superuser privileges.

   # psql -h <db.example.com> -U superuser -p 5432 -d postgres <Password for user superuser>:

   Where:

   -h hostname
   --host=hostname

   Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix-domain socket.

   -d dbname
   --dbname=dbname

   Specifies the name of the database to connect to. This is equivalent to specifying dbname as the first non-option argument on the command line. The dbname can be a connection string. If so, connection string parameters override any conflicting command line options.

   -U username
   --username=username

   Connect to the database as the user username instead of the default. (You must have permission to do so.)

2. Create the user, database, and password with the createDB or administrator role assigned to the user. For further information, see Database Roles.

3. Add the database credentials and host details to the automation controller inventory file as an external database.

   The default values are used in the following example:

   [database]
   pg_host='db.example.com'
   pg_port=5432
   pg_database='awx'
   pg_username='awx'
   pg_password='redhat'

4. Run the installer.

   If you are using a PostgreSQL database with automation controller, the database is owned by the connecting user and must have a createDB or administrator role assigned to it.

5. Check that you are able to connect to the created database with the user, password, and database name.
6. Check the permission of the user, the user should have the createDB or administrator role.

Procedure

1. Run a random write test:

   $ fio --name=write_iops --directory=/tmp --numjobs=3 --size=10G \
   --time_based --runtime=60s --ramp_time=2s --ioengine=libaio --direct=1 \
   --verify=0 --bs=4K --iodepth=64 --rw=randwrite \
   --group_reporting=1 > /tmp/fio_benchmark_write_iops.log \
   2>> /tmp/fio_write_iops_error.log

2. Run a random read test:

   $ fio --name=read_iops --directory=/tmp \
   --numjobs=3 --size=10G --time_based --runtime=60s --ramp_time=2s \
   --ioengine=libaio --direct=1 --verify=0 --bs=4K --iodepth=64 --rw=randread \
   --group_reporting=1 > /tmp/fio_benchmark_read_iops.log \
   2>> /tmp/fio_read_iops_error.log

3. Review the results:

   In the log files written by the benchmark commands, search for the line beginning with iops. This line shows the minimum, maximum, and average values for the test.

   The following example shows the line in the log file for the random read test:

   $ cat /tmp/fio_benchmark_read_iops.log
   read_iops: (g=0): rw=randread, bs=(R) 4096B-4096B, (W) 4096B-4096B, (T) 4096B-4096B, ioengine=libaio, iodepth=64
   […]
      iops        : min=50879, max=61603, avg=56221.33, stdev=679.97, samples=360
   […]

   You must review, monitor, and revisit the log files according to your own business requirements, application workloads, and new demands.