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