Change Postgres database settings for monetization

In Edge for Private Cloud, you might need to change the Postgres database settings, such as host, username, or password—for example: to implement a Postgres database failover. If you have Monetization Services enabled, you also need to modify the Monetization system settings for this change.

Use the following procedure to change Postgres database connection configurations for Monetization Services.

  1. Create a configuration file with the configurations below. The file should be readable by the apigee user.
    # IP address of a zookeeper node
    ZK_HOSTS=XX.XX.XX.XX
    
    # Postgres admin user and password
    PG_USER=apigee
    PG_PWD=postgres
    
    # Postgres Host IP
    MO_PG_HOST=XX.XX.XX.XX
    
    # Postgres user and password for monetization
    MO_PG_USER=postgre
    MO_PG_PASSWD=changeme
    
    # [OPTIONAL] Comma separated list of org names for which monetization is enabled
    MO_ORG_NAMES=org1,org2
  2. Run the following command on one of the management server nodes:
    $APIGEE_ROOT/apigee-service/bin/apigee-service edge-mint-management-server mint-pg-registration -f <path-to-config-file>
  3. Restart all Management server and Message processor nodes.
    $APIGEE_ROOT/apigee-service/bin/apigee-service edge-management-server restart
    $APIGEE_ROOT/apigee-service/bin/apigee-service edge-message-processor restart