search

galaxyproject / ansible-postgresql

An Ansible role for managing a PostgreSQL server
https://galaxy.ansible.com/galaxyproject/postgresql
121 stars 58 forks source link

Service name is incorrect on recent Debian-based systems #23

Open natefoo opened 4 years ago

natefoo commented 4 years ago

Recent Debian systems get a service named postgresql.service but restarting this actually does not restart PostgreSQL, for this you have to restart postgresql@<version>-<cluster> (e.g. postgresql@10-main).

hexylena commented 2 years ago

It has not been addressed in almost 2 years

yes we've been having a global pandemic, our bandwidth is lower than normal. galaxyproject is specifically a bioinformatics project heavily used during covid times, so, you can understand.

is it going to be maintained

we will be continuing to use it in production in a number of sites. It is up to you if you find this role useful or wish to find another one, or fork this one.

This is a major problem that you cannot use systemd to start the cluster installed by this ansible role

The cluster should get started, it is just that a restart handler wouldn't trigger a cluster restart properly.

MichaelDBA commented 2 years ago

Whoops, I accidentally deleted my issue comments. Thanks for your responses. Regarding the last comment, are you going to fix the restart handler so a restart can be done via ansible?

hexylena commented 2 years ago

Yes, it's very likely we will fix this, especially now that ubuntu support will grow as centos is ended. I cannot provide a timeline I'm afraid.