In reply to Gerry Nelson.

Thanks. I contacted TC and they gave me the default rules from 7.3 which were apparently missing in 7.1 (which was empty). I imported them and hopefully it should archive some to _archive tables next Monday. After that, I guess setup a cron to do what you have done, delete old data from these _archive tables. Again, very helpful post.

Just want to add that for UNIX users and envs where one can't just download tools off from web (pgAdmin), the needed psql CLI utility is available within the install folder itself on the server. For example, you need to add the LIB path to LD_LIBRARY_PATH and run psql from the server itself.

for example, if location of WIPDS is SASINSTALLLOC/sashome/SASWebInfrastructurePlatformDataServer/9.4/, then there will be a bin and lib folders under it. One needs to add lib to library path as below and then run the psql utility present in the bin folder.

$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/sasinstall/sashome/SASWebInfrastructurePlatformDataServer/9.4/lib

$ /sasinstall/sashome/SASWebInfrastructurePlatformDataServer/9.4/bin/psql -P 9432 -U xxxxxx -d SharedServices