systemd: Align the reference unit file with the production one

We now switched to using docker-compose to set up the postgres database as well, update the reference systemd service unit to match what we are using in production.