Setting Up the Genesys Administrator Extension Database (for PostgreSQL)

Use the following procedure to set up the PostgreSQL database that is used by Genesys Administrator Extension.

Note: It is recommended to use PostgreSQL versions 9.1.x.

If you prefer to use Oracle or Microsoft SQL Server, see Setting up the Genesys Administrator database (for Oracle) or Setting up the Genesys Administrator database (for Microsoft SQL Server).

  1. Refer to the PostgreSQL 9.1 documentation to create the PostgreSQL Database for GAX on the host machine.
  2. Start pgAdmin.
  3. Select the PostgreSQL 9.1 connection and connect to the PostgreSQL database with the following user name: postgres.
  4. Note:If a PostgreSQL 9.1 connection is not available, you can create it by clicking the Add Server button.
  5. Create a login and password for the GAX database.
    For example: gax814admin with the password password.
    You can execute queries by clicking the Query Tool button. For example:
    CREATE USER gax WITH PASSWORD 'gax814admin' CREATEDB;
  6. Create the GAX database (for example, gax814) by using the login created in Step 4 to make this login the owner of the database.
    create database gax814 owner gax;
  7. Connect to the database with the login that you created in Step 4.
  8. Perform the following steps if you are setting up a new Configuration Server:

Notes: