Re: Service not starting on Ubuntu 15.04

Adrian Klaver <adrian.klaver@xxxxxxxxxxx> · Mon, 26 Oct 2015 08:18:43 -0700

On 10/26/2015 08:04 AM, Lasse Westh-Nielsen wrote:
Adrian,

The service starts once the package is installed.

  - It did that on Ubuntu14.04
  - On Ubuntu 15.04, `sudo service postgresql status` _claims_ it has
been started.

Yes, it starts but it is a go nowhere, do nothing service:

    $ cat /etc/systemd/system/multi-user.target.wants/postgresql.service
    # 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

All it does is start /bin/true which is why the status shows it started, 
but Postgres does not run. My guess is the answer is in here:

http://askubuntu.com/questions/632882/does-upstart-really-handle-all-startup-scripts

Second answer

" PostgreSQL comes with two systemd service unit files in version 15, 
/lib/systemd/system/postgresql@.service and 
/lib/systemd/system/postgresql.service. System 5 rc stuff is thus 
completely ignored."

Best guess is /lib/systemd/system/postgresql@.service is the one that 
actually starts Postgres. Sort of confirmed by the comments in the 
service script above:

"# 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."

Pretty sure /lib/systemd/system/postgresql.service is just a placeholder 
script.

At any rate Stuarts answer and your application of it confirms the 
service script is the issue.

On Mon, Oct 26, 2015 at 2:57 PM, Adrian Klaver
<adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:

    On 10/26/2015 07:08 AM, Lasse Westh-Nielsen wrote:

        Adrian,

        Thanks. I know about the systemd change, and indeed the postgres
        package
        I end up with _has_ systemd integration already:

             $ cat
        /etc/systemd/system/multi-user.target.wants/postgresql.service
             # 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

    The thing above the above is I do not see anything that starts Postgres.

    Are you sure the same script is being called in cloud-init and
    outside of it?

    Or more to the point, what script actually starts Postgres?

    --
    Adrian Klaver
    adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general