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

Re: strange message from pg_dumpall

From: Thomas Pundt <mlists(at)rp-online(dot)de>
To: pgsql-general(at)postgresql(dot)org
Cc: Joao Miguel Ferreira <joao(dot)mc(dot)ferreira(at)criticalsoftware(dot)com>
Subject: Re: strange message from pg_dumpall
Date: 2007-10-31 11:52:00
Message-ID: 200710311252.00872.mlists@rp-online.de (view raw or flat)
Thread:
Lists: pgsql-general
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(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----

In response to

Responses

pgsql-general by date

Next:From: João Paulo ZavanelaDate: 2007-10-31 11:56:12
Subject: Re: configure password
Previous:From: Reg Me PleaseDate: 2007-10-31 11:23:14
Subject: Re: Join between tables of two or more databases

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