Postgres - Export error: Failed to execute pg_dumpall

Asked Nov 24 '15 at 05:31

Active Nov 24 '15 at 08:07

Viewed 1,783 times

i'm using PostgreSQL and i want to export my table in my database usng phppgadmin But the process does not allow me to do so and i'm getting this error

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

What should i do?

edited Nov 24 '15 at 08:07

asked Nov 24 '15 at 05:31

Iam Moon

what tool are you using to export your database? you aren't calling pg_dumall directly aren't you? – LongBeard_Boldy Nov 24 '15 at 07:11
you should use pg_dump with aditional parameters -Fp -t "mytable" --inserts – LongBeard_Boldy Nov 24 '15 at 07:18
i'm using phppgadmin to export my table – Iam Moon Nov 24 '15 at 08:04
Find config.inc.php inside your phppgadmin and change /usr/bin/pg_dumpall to correct locvation. Linux find / -name pg_dumpall – baklarz2048 Nov 24 '15 at 08:18
2

what location should i set? – Iam Moon Nov 24 '15 at 08:39
see this link: (https://github.com/xzilla/phppgadmin/commit/83e0f7de9d2ebac3949fb66709b582a40a38aab0) – mohammad hejazi Sep 12 '16 at 10:05

Postgres - Export error: Failed to execute pg_dumpall

0 Answers0