Re: [GENERAL] 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(at)rp-online.de> ---- 
http://rp-online.de/ ----

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               
http://www.postgresql.org/docs/faq