topic Root Partition Full in Firewall and Security Management

Root Partition Full

Eric_Merillat — Tue, 02 Feb 2021 13:14:06 GMT

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

Re: Root Partition Full

G_W_Albrecht — Tue, 02 Feb 2021 15:23:18 GMT

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...

Re: Root Partition Full

Eric_Merillat — Tue, 02 Feb 2021 17:40:52 GMT

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

Re: Root Partition Full

G_W_Albrecht — Tue, 02 Feb 2021 19:56:24 GMT

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)

Re: Root Partition Full

Eric_Merillat — Tue, 02 Feb 2021 19:58:16 GMT

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!

Re: Root Partition Full

Sergey_Golyak — Mon, 15 Feb 2021 17:54:24 GMT

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

Re: Root Partition Full

Eric_Merillat — Mon, 15 Feb 2021 23:41:53 GMT

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!

Re: Root Partition Full

FabioM1977 — Mon, 07 Jul 2025 13:23:48 GMT

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.

Re: Root Partition Full

Sergey_Golyak — Fri, 18 Jul 2025 13:48:40 GMT

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.