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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> 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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
