shell_exec problem

fernandodonster

I would like to take back of my database of postgress.
now i am doing the command "pg_dumb " which written in a shell script and run it on command promt
How it will do with PHP?
Can i use that shell script in the PHP?
Is there any need to establish database connection when using pg_dump.
My shell script was like:
pg_dump -f /root/backupfolder/testfile.sql -h sourcedomain databasename

It didnt worked with shell_exec. why?
I tried with the code
<?
shell_exec('pg_dump -f /root/backupfolder/testfile.sql -h sourcedomain databasename');
?>
what is the problem?
Is there any alternative solution to the problem??
give me a guidance
thanks in advance.

Horizon88

<?
shell_exec('g_dump -f /root/backupfolder/testfile.sql -h sourcedomain databasename');
?>

That says g_dump, not pg_dump...

fernandodonster

Horizon88 wrote:
<?
shell_exec('g_dump -f /root/backupfolder/testfile.sql -h sourcedomain databasename');
?>
That says g_dump, not pg_dump...

changed to pg_dump

but no change!

halojoy

fernandodonster wrote:
I would like to take back of my database of postgress.
now i am doing the command "pg_dumb "

According to your first post, you should use pg_dumb
Now you have tried:
g_dump
pg_dump
It wouldnt be difficult for you to find out what your script really called.
And so what you should use.
When you have tried the correct 'name' without working
then maybe we can start figure out what is wrong.

fernandodonster

My requirement is to take back of postgres database with shell_script within php.
how i dot it?

troybtj

The user that apache/php runs under doesn't have the same PATH environment as a shell account.

Use the full pathname to the pg_dump program, e.g.:

<?
shell_exec('/usr/sbin/pg_dump -f /root/backupfolder/testfile.sql -h sourcedomain databasename');
?>

--ETA: If you are on a *nix system, type which pg_dump to find the full pathname.

fernandodonster

I change the script with the current path.But not working still.
i used which pg_dump to get path and

path was /usr/bin/pg_dump
<?
shell_exec('/usr/bin/pg_dump -f /root/backupfolder/testfile.sql -h sourcedomain databasename');
?>

what is the problem???

thanks in advance

troybtj

Only two choices left that I can think of:

1) www-data/web user doesn't have exec permissions for pg_dump
2) You are in a SELinux or other secured system which would cause #1, but in a more complicated way.

fernandodonster

pls suggest an alternative solution to take backup of my postgres dattabase to a specified folder within the php file.My platform is linux fedora.
is there any php class to take backup in any sites?
thanks in advance.

troybtj

fernandodonster wrote:
pls suggest an alternative solution to take backup of my postgres dattabase to a specified folder within the php file.My platform is linux fedora.
is there any php class to take backup in any sites?
thanks in advance.

best advice would be to contact hosting company and see if they will set up a cron based backup of your database and either put it in your home directory (NOT web directory), or email it to you (depending on size.)