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.