Description:

The postgresql.service in systemd-arch-units contains the following line:

grep 'PID' /usr/lib/systemd/system/postgresql.service
PIDFile=/var/lib/postgres/data/postmaster.pid

However, PIDs should now go under /run. This causes PostgreSQL to fail to start when the following is ran:

systemctl start postgresql.service

Also of interest is:

$ systemctl status postgresql.service

sudo systemctl status postgresql.service
Password:
postgresql.service - PostgreSQL database server
Loaded: loaded (/etc/systemd/system/postgresql.service; enabled)
Active: failed (Result: exit-code) since Wed, 11 Jul 2012 10:16:38 +0100; 24min ago
Process: 252 ExecStop=/bin/su - postgres -m -c /usr/bin/pg_ctl -s -D /var/lib/postgres/data stop -m fast (code=exited, status=1/FAILURE)
Process: 229 ExecStart=/bin/su - postgres -m -c /usr/bin/pg_ctl -s -D /var/lib/postgres/data start (code=exited, status=0/SUCCESS)
Main PID: 250 (code=exited, status=1/FAILURE)
CGroup: name=systemd:/system/postgresql.service

Jul 11 10:16:37 callisto su[229]: pam_unix(su:session): session opened for user postgres by (uid=0)
Jul 11 10:16:38 callisto su[252]: pam_unix(su:session): session opened for user postgres by (uid=0)
Jul 11 10:16:38 callisto postgres[252]: pg_ctl: PID file "/var/lib/postgres/data/postmaster.pid" does not exist

Additional info:

* package version(s)

community/systemd-arch-units 20120612-7
extra/postgresql 9.1.4-1

Steps to reproduce:

* Run systemctl start postgresql.service
* Observe the errors in journalctl, and that PostgreSQL has not started.