Vacuum OTRS database

Moderator: crythias

Post Reply
Eric26
OTRS newbie
Posts: 9
Joined: 26 Jun 2015, 14:56
OTRS Version?: 4.0.8
Real Name: Eric
Company: PREF26

Vacuum OTRS database

Post by Eric26 »

Hi all!

I'm using OTRS 4.0.3 appliance for few monthes. It's running with PostgreSql 8.4 database and this one is going to be larger and larger.
Now, my database size is 9563 MB and occupies 85% of disk space (OTRS is set on a VmWare virtual machine).

I've tried to prune old tickets using automated tasks but this don't help to save disk space. Is it a way to compress the database by using (i.e.) a vacuum command line ? Could the vacuum command help ?

I tried it but psql command line ask me to enter a login and password... and i've no idea of this! Tryed login used in appliance installation process without any success.

I'll greatly appreciate any help to fix my disk space issue without growing the disk size.

Regards,
Eric

Daniel Obee
Moderator
Posts: 644
Joined: 19 Jun 2007, 17:11
OTRS Version?: various
Real Name: Daniel Obée
Location: Berlin

Re: Vacuum OTRS database

Post by Daniel Obee »

The easiest way of keeping the DB small is to store attachments in the filesystem as described in https://otrs.github.io/doc/manual/admin ... rs-storage

The filesystem can easily put on a different server/storage.

Best
Daniel

Post Reply