Home / server / Questions / 797842
Accepted
David Tinker
Asked: 2016-08-19 22:59:16 +0800 CST

How can I allow a normal user to stop Postgresql on Ubuntu 16.04?

  • 772

My user is 'peaagent'. I have tried visudo -f /etc/sudoers.d/peaagent with the following:

peaagent ALL = (root) NOPASSWD: /bin/systemctl stop postgresql.service

When I try stop Postgresql as peaagent it prompts me for a password:

peaagent@myserver:~$ /bin/systemctl stop postgresql.service
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to stop 'postgresql.service'.
Authenticating as: root
Password:

Anyone know why this doesn't work? Tx.

ubuntu sudo ubuntu-16.04

1 Answers

  1. Best Answer

    Your problem is that you are not prefixing your command with sudo. As you are attempting to run a systemd command without sufficient privilege, systemd is asking for a password (via systemd-ask-password) to a suitably privileged account. 

    sudo  /bin/systemctl stop postgresql.service

    should do what you want.

    • 3