mirror of
https://gitlab.archlinux.org/archlinux/infrastructure.git
synced 2026-08-04 10:22:59 +02:00
11 lines
316 B
SYSTEMD
11 lines
316 B
SYSTEMD
[Unit]
|
|
Description=Clean up Quassel backlog
|
|
Requisite=postgresql.service
|
|
After=postgresql.service
|
|
|
|
[Service]
|
|
User=postgres
|
|
Type=oneshot
|
|
ExecStart=/usr/bin/psql -a -d quassel -c "DELETE FROM backlog WHERE time < NOW() - INTERVAL '1 months';"
|
|
ExecStart=/usr/bin/psql -a -d quassel -c "VACUUM VERBOSE ANALYZE backlog;"
|