mirror of
https://gitlab.archlinux.org/archlinux/infrastructure.git
synced 2025-01-18 08:06:16 +01: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;"
|