Обсуждение: Problem with dumps
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. 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 rebooted the server just to be sure. Unfortunately, though having the correct paths helped a fair bit, it's not working correctly when performing an export in phppgadmin. Data / Copy / Show or Download = OK Data / SQL / show or download = blank Structure / SQL / Show or download = OK Structure and data / copy /show or downlad = OK Structure and data / SQL /show or downlad = blank Anyone know what's up? Thanks! -- 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/>
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/> 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/>
>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&aid=2883104&group_id=37132&atid=418980> -- 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/>