Root Partition Full

[Eric_Merillat]

The root partition filled up overnight and using du I have narrowed it down to /opt/CPshrd-R80.40/database/postgresql/data/log is taking up the majority of the drive space.  Is there a safe way to purge these files and free up the drive space?  I searched the support site and this site for this issue but was not able to find anything.

Thanks in advance,

Eric

[G_W_Albrecht]

I looked at my /opt/CPshrd-R80.40/database/postgresql/data/ directory and found folder base to contain the big date - but o could not find /opt/CPshrd-R80.40/database/postgresql/data/log ! This is a R80.40 JT 92 SMS. Anyway, it is not a good idea to delete something in a CP installation without good reason and instructions.

Maybe it is the issue from sk166555: PostgresSQL database is very big and continues to grow ? Better involve TAC here...

[Eric_Merillat]

The database is normal sized it is just the log folder that is excessive.  The output from that SK shows it is not that issue.  

psql_client cpm postgres -c "select count(*) from dleobjectderef_data where deleted and dlesession=0"

count

-------

   858

(1 row)

Digging deeper into it there are several revisions that were created by the Web API when Cloudguard was deployed in NSX yesterday evening so wondering if that may have anything to do with this.  

Thanks,
Eric

[G_W_Albrecht]

What about exploring the log folder ? Should also not be an issue to delete logs you do not need....

Still i would suggest to contact TAC - i smell a bug here 8)

[Eric_Merillat]

Yeah, I will have them open a TAC case, I expanded the root partition this morning to keep us working but it has already grown another 3 Gb today.  

Thanks!

[Sergey_Golyak · Accepted solution]

I assume that you have already resolved the issue. I had similar one, it was resolved by issuing $FWDIR/scripts/postgres_logs_off.sh.

[Eric_Merillat]

That was exactly the problem!  Someone had enabled debugging in postgres.  TAC found this and we turned it off and deleted the logs!  I should have come back and posted the solution but thanks for your answer!

[FabioM1977]

HI Sergey,

years go by but Checkpoint still has the same problems. I followed your advice and stopped the Postgres logs. By chance, but I know I ask a lot, do you also remember what you deleted afterwards to free up space?

Thanks.

[Sergey_Golyak]

Hi Fabio,

I don't remember already what I did, too many time passed. Anyway, there is sk60080 that describes common way of managing this type of problems.