Apigee Private Cloud 16.01 - Postgres Data Purge Problem

Problem

In 16.0x and newer we have an apigee-service called 'pg-data-purge' which is used to purge analytics data based on the number of days you would like to retain.

> /opt/apigee/apigee-service/bin/apigee-service apigee-postgresql pg-data-purge <Org><Env><NoOfDaysToPurgeBackFromCurrentDate>

In the 16.01 release there is a bug in the pg-data-purge service which does not properly authenticate the correct user. When running the pg-data-purge service, you may see this error:

ERROR: must be owner of relation org.env.fact_#### 

Solution

In the /opt/apigee/apigee-postgresql-9.4.9-x.x.xxx/lib/actions/pg-data-purge, update the line:

POSTGRES_USER=postgres

to:

POSTGRES_USER=apigee

This problem has been fixed in Private Cloud 16.05 and newer.

Version history
Last update:
‎02-21-2017 05:19 PM
Updated by: