sudo -u postgres

pkraus109 · 01-04-2012, 06:12 AM

I have a virtual machine running ubuntu server (latest LTS forget the actual version number). I have setup sudo not to ask for a password but when I did that I could no longer do this ...

sudo -u postgres psql

I know get a password prompt and then this message after i enter my password ...

Sorry, user _____ is not allowed to execute '/usr/bin/psql' as postgres on teletraan1.pelsupply.com.

sudoers ...
root ALL=(ALL) ALL
%admin ALL=NOPASSWD: ALL

TIA!

ochienged · 01-04-2012, 08:56 AM

First you need to confirm that postgres is a member of the group admin. You can do that as below

Quote:

groups postgres | cut -d':' -f2

If so, then you seem to have a problem with the formatting of the sudo line for the group admins. The line that begins with '%admin'. It should appear as below

Quote:

%admin ALL=(ALL) NOPASSWD: ALL

If postgres is not a member of the group admin, you can add him as below

Quote:

usermod -G admin postgres