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 <[EMAIL PROTECTED]> ---- http://rp-online.de/ ---- ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq