Re: strange message from pg_dumpall

On Mittwoch, 31. Oktober 2007, Joao Miguel Ferreira wrote:
| 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.
| --------------------------------------
[...]
| This is what I do:
|
| system("su postgres -c \"pg_dumpall --clean > some_file\"");

I'd try "su - postgres ..."; this will use postgres' environment here.

| 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 !!!???

What does "type -a pg_dump" output? Maybe it's a leftover from an
incomplete uninstall of a PostgreSQL installation?

Ciao,
Thomas

--
Thomas Pundt <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----