The following function is used to execute pg_dump but have no responding at all. And I found there is no output. While the exactly command string executing on server desktop does work. And I have another function to execute a program saved in somewhere rather than "program files" and it works. php safe_mode is off.
Code:
function create_new_csn_schema($xfrom_schema, $xtoschema){
$cmd ="\"c:\\program files\\PostgreSQL\\9.0\\bin\\pg_dump.exe\" --file=c:\\temp\my1.sql --host=localhost --username=xyz --port=5111 --table=$xfrom_schema.* --schema=$xfrom_schema --schema-only mydb";
$WshShell = new COM("WScript.Shell");
$exec = $WshShell->Run($cmd, 0, true);
}
Comment