X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/3087ac1145f148adcfbb4abeb31bcc62d062b1bd..62747c934d3445b000810f8a7737ea86777995e3:/lib/cmd.php diff --git a/lib/cmd.php b/lib/cmd.php index 28d56f2e..8ccbb036 100644 --- a/lib/cmd.php +++ b/lib/cmd.php @@ -158,6 +158,16 @@ function runSQLScript($sScript, $bfatal = true, $bVerbose = false, $bIgnoreError $aDSNInfo = DB::parseDSN(CONST_Database_DSN); if (!isset($aDSNInfo['port']) || !$aDSNInfo['port']) $aDSNInfo['port'] = 5432; $sCMD = 'psql -p '.$aDSNInfo['port'].' -d '.$aDSNInfo['database']; + if (isset($aDSNInfo['hostspec']) && $aDSNInfo['hostspec']) { + $sCMD .= ' -h ' . $aDSNInfo['hostspec']; + } + if (isset($aDSNInfo['username']) && $aDSNInfo['username']) { + $sCMD .= ' -U ' . $aDSNInfo['username']; + } + $procenv = null; + if (isset($aDSNInfo['password']) && $aDSNInfo['password']) { + $procenv = array_merge(array('PGPASSWORD' => $aDSNInfo['password']), $_ENV); + } if (!$bVerbose) { $sCMD .= ' -q'; } @@ -170,7 +180,7 @@ function runSQLScript($sScript, $bfatal = true, $bVerbose = false, $bIgnoreError 2 => STDERR ); $ahPipes = null; - $hProcess = @proc_open($sCMD, $aDescriptors, $ahPipes); + $hProcess = @proc_open($sCMD, $aDescriptors, $ahPipes, null, $procenv); if (!is_resource($hProcess)) { fail('unable to start pgsql'); }