Joao Miguel Ferreira <joao.mc.ferreira@criticalsoftware.com> writes:
> 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 !!!???
Maybe strace would yield some useful info, ie
system("su postgres -c \"strace -f pg_dumpall --clean > some_file 2>strace.out\"");
What platform and PG version is this exactly?
regards, tom lane