strange message from pg_dumpall

From: Joao Miguel Ferreira <joao(dot)mc(dot)ferreira(at)criticalsoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: strange message from pg_dumpall
Date: 2007-10-31 09:56:40
Message-ID: 1193824600.4079.3.camel@azagthot.critical.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

I got surprised by this message:

-------------------------------------
The program "pg_dump" is needed by pg_dumpall but was not found in the
same directory as "/usr/bin/pg_dumpall".
Check your installation.
--------------------------------------

It's quite strange because I'm quite the pg_* binaries are well
installed:

----------------------------------------
$ ls -la /usr/bin/ | grep pg_
-rwxr-xr-x 1 admin root 16632 Oct 16 17:39 pg_config
-rwxr-xr-x 1 admin root 16636 Oct 16 17:39 pg_controldata
-rwxr-xr-x 1 admin root 24880 Oct 16 17:39 pg_ctl
-rwxr-xr-x 1 admin root 187996 Oct 16 17:39 pg_dump
-rwxr-xr-x 1 admin root 43444 Oct 16 17:39 pg_dumpall
-rwxr-xr-x 1 admin root 23020 Oct 16 17:39 pg_resetxlog
-rwxr-xr-x 1 admin root 84460 Oct 16 17:39 pg_restore
$
----------------------------------------

This is what I do:

system("su postgres -c \"pg_dumpall --clean > some_file\"");

this is run from within a Perl module called from within a Perl script.

I've tried the same command directlly on the shell and it works fine.
But from the perl script it complaints about pg_dump !!!???

I've even tested both commands directlly on the cmd line and they work
properlly !

any ideas ?

thx
joao

Responses

Browse pgsql-general by date

  From Date Subject
Next Message João Paulo Zavanela 2007-10-31 10:33:33 configure password
Previous Message Reg Me Please 2007-10-31 07:41:44 Re: