• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

postgresql database expanding out of control

Brazen

Diamond Member
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?
 
Back
Top