Configuring PostgreSQL

Configuring PostgreSQL is divided into the following steps:

1. Connecting as a PostgreSQL user
2. Starting the Administration Tool
3. Creating a user for BMC Client Management

1. Type the command # su - postgres to activate the PostgreSQL user into a terminal window.

   All administrative operations are initially carried out by the PostgreSQL user. However, at the end of the installation process this user does not have a password, that is, the user account is blocked. You therefore need to activate the user to be able to carry out all required administratrive operations.

1. Type the command # psql to start the administration tool:

1. Type the command # CREATE USER <username>; to create the Client Management user.

2. Enter the command # ALTER ROLE <username>; .

   By doing so you provide the user the possibility to create new databases.

3. Enter the command # CREATE DATABASE <database_name> OWNER <username>; to create a database.

   If you give the database the same name as the user you connect to it with, the client connects with that database by default.

4. Enter the command # ALTER USER <username> WITH ENCRYPTED PASSWORD <mypassword>; to assign the user a password.

   Assigning the user a password is necessary to establish a connection with the database. The ENCRYPTED option allows the use of md5 in the pg_hba.conf file.

5. Enter # \q to quit pgSQL.
6. Enter # exit to log the PostgreSQL user off.

The database is now set up and configured for use with the BMC Client Management agent. However, before you can install the CM master on this computer, you need to ensure that the prerequisites that are listed in the Prerequisites for Postgres 9 and later topic in the Linux Installation section are fulfilled.