sudoers syntax to run shell script as php user?

Question

I want to run

the script will have few lines of code, something like

dropdb <database name>
psql -c "create database <database name> with encoding 'unicode';" -U edutemplate1
psql -d <database name> -f edu.hourly.sql

what would be the sudo command syntax to run the script restore
what would be the sudoers syntax to allow php user to run restore script as postgres user?

zerkms · Accepted Answer · 2011-03-28 02:11:29Z

2

The command is absolutely the same as you do in console:

sudo -u db1inst1 /path/to/script.sh

Or even:

system('sudo -u db1inst1 /path/to/script.sh');

or

`sudo -u db1inst1 /path/to/script.sh`

answered Mar 28, 2011 at 1:58

zerkms

256k73 gold badges447 silver badges551 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

With a default sudoers, that's going to run it as root, not as php.