Mar 28, 2016

Homebrew-ed Postgresql: "Export error: Failed to execute pg_dump"

Problem to troubleshoot
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.

Postgres phppgadmin: Export error
I am new to postgresql database,
and recently I have a chance to play with this technology and at the meantime, I have been facing newbie issues with it.

Since I won't using this tool for a long time, it's better to record down the troubleshooting note for future in the simple way.

I use homebrew to install postgresql and phppgadmin.

As said in the error message, we'll need to edit conf/config.inc.php in order to get it fixed.

1) find your config.inc.php with "mdfind -name config.inc.php"
search for config.inc.php file
2) Find your pg_dump binary file path with "which pg_dump"
pg_dump location
3) Place correct path to "pg_dump" configuration

4) Once you done steps above, remember to relogin your user in phppgadmin for changes above to take effect.


1 comment:

  1. Confronting Error while Installing the PostgreSQL? Contact to Postgres SQL Support for Windows
    This PostgreSQL establishment blunder for the most part looked by the new client who changes from another database to Postgres. Anyway there is definitely not a major ordeal for those clients who stand up to this issue since its normal. Having some specialized abilities you can undoubtedly dispose of this issue. For this situation the most well-known arrangement is basically expelled and reinstalls the PostgreSQL. And furthermore ensure that your area is introduced. In the wake of attempting these means if as yet confronting a similar issue at that point contact to Cognegic's Postgres SQL Support for Linux or PostgreSQL Remote Database Service to defeat of this issue.
    For More Info: https://cognegicsystems.com/
    Contact Number: 1-800-450-8670
    Email Address- info@cognegicsystems.com
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

    ReplyDelete

Hey, thank you for spending time leaving some thoughts, that would be really helpful as encouragement for us to write more quality articles! Thank you!