db dump from php

Поиск
Список
Период
Сортировка
От jody
Тема db dump from php
Дата
Msg-id CAKbzMGeFyiFSmaK_GMe7TFBQzZrGSTZLFUVHf9Kad_avQ7twMA@mail.gmail.com
обсуждение исходный текст
Ответы Re: db dump from php
Re: db dump from php
Список pgsql-novice
Дерево обсуждения 
Hi
I have a problem when creating a db dump from a php script in a html page.
This used to work in previous PostgreSQL versions, but now (v, 9.1.5)
it fails, and i have no idea why.

It is not a matter of write-access, since  the directory has mode 777,
and in the same php-file i successfully create a file there.

Here's a minimal version which shows the behavior:

<html>
<head></head>
<body>
<?php
    putenv('PG_USER=magnus');
    putenv('PG_PASSWORD=mypass');
    putenv('PG_DB=magnus2');
    putenv('PG_HOST=localhost');
    putenv('PGPASSFILE=/home/jody/.pgpass');

    $sPath="/home/jody/progs/magnus2/dumps/dumpidump.sql";
    $sDBName="magnus2";
    $sQuery1="/usr/bin/pg_dump -w -U magnus  -c -f $sPath $sDBName";

    exec($sQuery1, $output, $iRet);

    print("Q:" . $sQuery1 . "<br/>");
    print("ret:" . $iRet . "<br/>");
    foreach($output as $ss) {
        print("out:" . $ss . "<br/>");
    }

    print("<hr/>\n");

    $sQuery2="echo gnagna > " . $sPath . ".test";
    exec($sQuery2,  $output, $iRet);
    print("Q:" . $sQuery2 . "<br/>");
    print("ret:" . $iRet . "<br/>");
    foreach($output as $ss) {
        print("out:" . $ss . "<br/>");
    }
?>
The call to pg_dump fails with a return code of 1, and $output is empty.
The second call succeeds with return code 0, and a file is indeed written.

When i replace $sQuery1 by "/usr/bin/pg_dump --version" the cal
succeeds with return code 0,
and $output contains the string "pg_dump (PostgreSQL) 9.1.5"

When i copy-paste the command contained in $sQuery to the command line,
it succeeds.

In my home directory /home/jody i have .pgpass file, with the correct
username and password.

Is there a way to specify a password on the command line?
Can somebody give me a hint how i can get this to work?

Thank You
  Jody

В списке pgsql-novice по дате отправления: