empty output when calling pg_dump under php code

Question

I need to make a dump via pg_dump in php so i've got a function like this:

function fnDump()
{
    exec("/usr/local/bin/sudo -u pg_user /usr/local/bin/pg_dump mon_alarm > /usr/home/user/monitor_test/renew_db/mon_alarm.sql",$out);
    var_dump($out);
}

The problem is that mon_alarm.sql file is empty. But when i execute this command via command line everything works fine. What should i change to create a dump in php?

onteria_ · Accepted Answer · 2011-05-30 11:13:22Z

3

If you're running PHP under a standard webserver setup, that won't work because it will run under the context of the webserver user, so sudo won't let you change user context like that.

If this is a script you're going to have to adjust sudo to run only the pg_dump command as passwordless sudo permissions for the user, otherwise your sudo command will prompt for a password and ruin your automated process.

answered May 30, 2011 at 11:13

onteria_

70.9k7 gold badges73 silver badges64 bronze badges

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

1 Comment

k102 Over a year ago

thanks! i thought that adding nopasswd permission for psql is enough.

Collectives™ on Stack Overflow

empty output when calling pg_dump under php code

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related