Search Postgresql Archives

Re: Problem with dumps

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/>

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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux