[Pkg-postgresql-public] Bug#755894: systemd does not start postgresql

[Erik de Castro Lopo]

Erik de Castro Lopo wrote:

> Installed postgresql 9.3+157 on a system which already had systemd as its
> init system. When i try to start postgresql:
> 
>     # systemctl start postgresql
>     # systemctl status postgresql
>     postgresql.service - LSB: PostgreSQL RDBMS server
>        Loaded: loaded (/etc/init.d/postgresql)
>        Active: active (exited) since Tue 2014-07-22 10:40:04 EST; 2 days ago
> 
> This looks like : https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=731862
> 
> That bugs asks for an strace output. That should be attached to this report.

Ah this is weird!

It seems systemctl doesn't know how do find the status of the postgresql
daemon. Turns out the systemd service file for postgresql is complete
rubbish:

    # systemd service for managing all PostgreSQL clusters on the system. This
    # service is actually a systemd target, but we are using a service since
    # targets cannot be reloaded.

    [Unit]
    Description=PostgreSQL RDBMS

    [Service]
    Type=oneshot
    ExecStart=/bin/true
    ExecReload=/bin/true
    RemainAfterExit=on

    [Install]
    WantedBy=multi-user.target

This is obviously wrong.


Erik
-- 
----------------------------------------------------------------------
Erik de Castro Lopo
http://www.mega-nerd.com/