Problem with dumps

Le 09/08/2010 20:04, Bill Christensen a �crit :

Hi folks,

I'm building a new server with postgres/phppgadmin, and having trouble
getting the dumps to work properly. This is my first time installing
postgres, so I very well may have missed something.

Do you use the same server for PostgreSQL and phpPgAdmin? if not, the
pg_dump executable has to be on the server with phpPgAdmin.

I just corrected the paths to pg_dump and pg_dumpall.

By the way, what's "relog" mean in the error message:

Export error: Failed to execute pg_dump (given path in your
conf/config.inc.php :
/usr/bin/pg_dump). Please, fix this path in your configuration and
relog.

I suppose it means you need to disconnect and reconnect before it can
use the new configuration.

--
Guillaume
http://www.postgresql.fr
http://dalibo.com

At 9:55 AM +0200 8/11/10, Guillaume Lelarge wrote:

Le 09/08/2010 20:04, Bill Christensen a écrit :

Hi folks,

I'm building a new server with postgres/phppgadmin, and having trouble
getting the dumps to work properly. This is my first time installing
postgres, so I very well may have missed something.

Do you use the same server for PostgreSQL and phpPgAdmin? if not, the
pg_dump executable has to be on the server with phpPgAdmin.

Thanks for the reply. Now at least I know that my emails are getting through!

Yes, PostgreSQL and phpPgAdmin are on the same server.

Export error: Failed to execute pg_dump (given path in your
conf/config.inc.php :
/usr/bin/pg_dump). Please, fix this path in your configuration and
relog.

I suppose it means you need to disconnect and reconnect before it can
use the new configuration.

Well, I tried both a reboot and logout/login, with no success yet.

At 5:15 PM +0200 8/11/10, Jens Wilke wrote:

Am Mittwoch 11 August 2010 16:20:27 schrieb Bill Christensen:

Hi,

Export error: Failed to execute pg_dump (given path in your
conf/config.inc.php :

Is pg_dump executable?

I hadn't thought to check that.

Everything in that directory is rwxr-xr-x root
admin. Could it be an ownership or group problem?

Did you try to do a manual dump w/o phpadmin?

Hmm. I'm getting a "role 'root' does not exist"
error, though I've got --role=billc -W (a working
user name and password) in there.

I did a search in the wiki and don't see
anything to address that specifically, though
there's stuff about getting that response when
you're calling a user that doesn't exist.

Is the file owner being 'root' the problem? Should it be 'postgres'?
--
Bill Christensen
<http://greenbuilder.com/contact/&gt;

Green Building Professionals Directory: <http://directory.greenbuilder.com&gt;
Sustainable Building Calendar: <http://Calendar.SustainableSources.com&gt;
Green Real Estate: <http://www.greenbuilder.com/realestate/&gt;
Straw Bale Registry: <http://sbregistry.greenbuilder.com/&gt;
Books/videos/software: <http://bookstore.greenbuilder.com/&gt;

Le 09/08/2010 20:04, Bill Christensen a écrit :

Hi folks,

I'm building a new server with postgres/phppgadmin, and having trouble
getting the dumps to work properly. This is my first time installing
postgres, so I very well may have missed something.

Just to let y'all know, I got a response today
from the phpPgAdmin help forum which solved the
problem.

The exports in the current non-beta release of
phpPgAdmin doesn't work properly with
Postgres8.4. See:
<https://sourceforge.net/tracker/?func=detail&amp;aid=2883104&amp;group_id=37132&amp;atid=418980&gt;

--
Bill Christensen
<http://greenbuilder.com/contact/&gt;

Green Building Professionals Directory: <http://directory.greenbuilder.com&gt;
Sustainable Building Calendar: <http://Calendar.SustainableSources.com&gt;
Green Real Estate: <http://www.greenbuilder.com/realestate/&gt;
Straw Bale Registry: <http://sbregistry.greenbuilder.com/&gt;
Books/videos/software: <http://bookstore.greenbuilder.com/&gt;