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).
- Refer to the PostgreSQL 9.1 documentation to create the PostgreSQL Database for GAX on the host machine.
- Start pgAdmin.
- Select the PostgreSQL 9.1 connection and connect to the PostgreSQL database with the following user name: postgres.
Note:If a PostgreSQL 9.1 connection is not available, you can create it by clicking the Add Server button.
- 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;
- 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;
- Connect to the database with the login that you created in Step 4.
- Perform the following steps if you are setting up a new Configuration Server:
- You must update the DBMS configuration file pg_hba.conf to allow the client to connect to the database.
- Issue the command pg_ctl reload to complete the update of the DBMS configuration file.
Notes:
- The PostgreSQL driver LIBPQ.dll must be installed on the host where Database Server is installed.
- The PATH environment variable must be set to the bin directory of PostgreSQL.