3CX: Clear Large Syslog

After U7 upgrade, syslog might become very big. Delete it by running:

sudo -i
df -h
truncate -s 0 /var/log/syslog
truncate -s 0 /var/log/syslog.1
df -h

If there still isn't much space:

First do a 3CX backup and download it.

Find large folder with:

sudo -i

cd /var/lib/postgresql/15/main/base/

du -h --max-depth=1 | sort -hr

If a folder is very big, the folder name is the table ID.

Stop the 3CX services:

sudo systemctl stop 3CX*

# Log in to psql as postgres user

sudo -u postgres psql

# Connect to your 3CX database

\c database_single

# Run this query to find the table name from its file OID

SELECT n.nspname AS schema_name, c.relname AS table_name

FROM pg_class c

JOIN pg_namespace n ON n.oid = c.relnamespace

WHERE c.relfilenode = 27145;

-- Replace public.table_name with the name from Step 3

TRUNCATE (schema).(table_name);

# Exit from PSQL

\q

sudo systemctl start 3CX*