I have an application, it's actually Trend Micro's Internet Security Suite, that requires a Postgresql database (otherwise I would be using MySQL). There is a folder that is steadily and slowly growing by a couple megabytes a day. The folder is pgdata/base/16385/. Inside that folder are sequentially numbered files that are either 0 bytes or 8192 bytes.
I don't know if this is the database location for the application or if it is just something used by pgsql, but the application should not be accumulating data. It only stores settings and logs and the logs get deleted after a month. I'm wondering if maybe these are transaction logs created by the database that just need cleaned up, or if the application is actually storing that much data in pgsql and the application needs fixed.
Any ideas?
I don't know if this is the database location for the application or if it is just something used by pgsql, but the application should not be accumulating data. It only stores settings and logs and the logs get deleted after a month. I'm wondering if maybe these are transaction logs created by the database that just need cleaned up, or if the application is actually storing that much data in pgsql and the application needs fixed.
Any ideas?