Chapter 8. Use a PostgreSQL Database Server with Red Hat Gluster Storage Console

Procedure 8.1. Manually Preparing a PostgreSQL Database Server for use with Red Hat Gluster Storage Console

1. Initialize the database and start the postgreSQL service by running the commands:

   # service postgresql initdb
   # service postgresql start

   Copy to Clipboard Toggle word wrap
2. Create a postgreSQL user for the Red Hat Gluster Storage Console to use when it reads from and writes to the database, and a database to store information about the environment in. This step is required on both local and remote manually configured database servers.

   # su - postgres
   $ psql            
   postgres=# create user USER password 'PASSWORD';
   postgres=# create database DATABASE owner USER;

   Copy to Clipboard Toggle word wrap
3. Make sure that database can be accessed remotely by enabling client authentication. This step is required on manually configured remote database servers. Edit the /var/lib/pgsql/data/pg_hba.conf file, and add this line:

   host all all X.X.X.X/24 trust

   Copy to Clipboard Toggle word wrap
   Replace X.X.X.X with the IP address of the Console server.
4. Allow TCP/IP connections to the database. This step is required on manually configured remote database servers. Edit the /var/lib/pgsql/data/postgresql.conf file, and add this line:

   listen_addresses='*'
   port = 5432

   Copy to Clipboard Toggle word wrap
   This example makes postgreSQL listen for connections on all interfaces. You can specify an interface by giving its IP address.This requires a restart of the postgreSQL server.
5. Restart the postgres service. This step is required on both local and remote manually configured database servers.

   service postgresql restart

   Copy to Clipboard Toggle word wrap

Procedure 8.2. Configuring the Manager to use a Manually Configured Local or Remote PostgreSQL Database

1. During the Red Hat Gluster Storage Console installation using the rhsc-setup utility, you are prompted to decide where the database is located.

   Where is the database located? (Local, Remote) [Local]:

   Copy to Clipboard Toggle word wrap
   The steps involved in manually configuring the Red Hat Gluster Storage Console to use remote and local databases are the same, except that to use a remotely hosted database, you need to provide the hostname of the remote database server, and the port it is listening on.
2. If you are using a remote manually configured database, supply the rhsc-setup utility with the hostname of the database server and the port it is listening on.

   Database host [localhost]:
   Database port [5432]:

   Copy to Clipboard Toggle word wrap
3. In either case, you are prompted to confirm whether the database uses a secured connection. Provide a username and password for the newly configured database.

   Database secured connection (Yes, No) [No]: 
   Database name [engine]: 
   Database user [engine]: 
   Database password:

   Copy to Clipboard Toggle word wrap

   Note

   Using a secured connection to the database requires you to have also manually configured secured database connections.