SONG technical management tasks page

Update status of task:
Description of task:Database problems on central

Updated by
(Re)assign to
New status
Comment
Expected handled on Expected to be handled on? [YYYY-MM-DD]


Old comments:

2024-04-24 09:25: [Mads]: The database backup system - barman - was not running and therefore did not clear WAL files. This is fixed and database dumps to ERDA has also been setup. The virtual machine central is still hanging some times which might be caused by the server not having enough CPU's

2023-07-11 11:41: [Mads]: The central database was again running full. Removed an old postgresql version using 32 GB and cleared all write-ahead.log files older than 10 days ago using pg_archievecleanup command. Seems like too db changes are logged. Most likely needs reconfiguration of specific tables.