Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: João Paulo ZavanelaDate: 2007-10-31 10:33:33
Subject: configure password
Previous:From: Reg Me PleaseDate: 2007-10-31 07:41:44
Subject: Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group