Re: [ppa-users] Export fails

[Wolf S. <wo...@ue...>]

I also tested pg_dumpall on the web host from the command line this works

$ /usr/lib/postgresql/9.5/bin/pg_dumpall -a -h pgdev-db -f all.sql

From: Wolfgang Schwurack <wo...@ue...>
Date: Wednesday, August 17, 2016 at 8:33 AM
To: "php...@li..." <php...@li...>
Subject: Re: [ppa-users] Export fails

I tested pg_dump on phppgadmin host to database host using the command line which created the dump file but still fails using the web application.

$ /usr/lib/postgresql/9.5/bin/pg_dump -Ft -U wolf -h pgdev-db -d go -f go.sql

From: Wolfgang Schwurack <wo...@ue...>
Date: Wednesday, August 17, 2016 at 8:11 AM
To: "php...@li..." <php...@li...>
Subject: Re: [ppa-users] Export fails

So figure out that phpPgAdmin is looking at the path that installed on the host that phpPgAdmin is installed on not the database host.
I installed postgresql 9.5 on the phpPgAdmin host. Now when I try to export ad database I just get a blank screen. I checked the mailing list said to check user’s permissions which the user I’m using has superuser permissions.
Anyone know why I’m getting a blank screen when trying to export a database using phppgadmin?

Thanks
Wolf

From: Wolfgang Schwurack <wo...@ue...>
Date: Tuesday, August 16, 2016 at 11:36 AM
To: "php...@li..." <php...@li...>
Subject: [ppa-users] Export fails

When I try export a database using phppgadmin 5.1 the export fails with

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

I have verified that the path is correct on the postgresql host and can be executed

postgres@pgdev-db:~$ which pg_dumpall
/usr/lib/postgresql/9.5/bin/pg_dumpall
postgres@pgdev-db:~$ ll /usr/lib/postgresql/9.5/bin/pg_dumpall
-rwxr-xr-x 1 postgres postgres 92K May 10 09:39 /usr/lib/postgresql/9.5/bin/pg_dumpall*

Wolfgang Schwurack
Database/System Administrator
Utah Education Network
801-587-9444
wo...@ue...<mailto:wo...@ue...>