Search Postgresql Archives

Re: Service not starting on Ubuntu 15.04

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Just out of curiosity, is there anything in the postgresql.log which gives an indication of a problem?

On Mon, Oct 26, 2015 at 11:18 AM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
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



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux