postgreSQL dump file generated when exporting is blank

Question

I have a database named housing that I want to export. However, everytime i export it, it generates a blank dump file. I cannot identify what I've been doing wrong. Please help.

I'm trying using phppgadmin, I clicked export, selected SQL, structure and data as format and then download, but the dump file generated is always blank.

I think I know now what the problem is, I have different two versions of postgreSQL installed on my laptop. postgreSQL version 9.3.6 that comes with Bitnami WAPPstack) and I forgot that I had previously installed postgreSQL version 9.4.1 too. I get a pg_dump aborting because of server version mismatch. How do I fix this? Can I just simply uninstall the one that is not with the Bitnami WAPPStack? Or will my database be deleted along with it? I'm sorry I know nothing . :(

Are you trying to export it via terminal or phppgadmin or pgadmin3. Also please share the code too. — Nandakumar V
– Nandakumar V, Commented Jun 2, 2015 at 11:56
I'm trying using phppgadmin, I clicked export, selected SQL, structure and data as format and then download, but the dump file generated is always blank. @NandakumarV — user2332475
– user2332475, Commented Jun 2, 2015 at 13:11
From which page you have clicked the export link? You should click export from the page with list all tables. — Nandakumar V
– Nandakumar V, Commented Jun 2, 2015 at 15:35
Dumping of complex table and schema names on Windows is not supported. --This is now what the dump file is saying — user2332475
– user2332475, Commented Jun 2, 2015 at 16:13
Ahh... windows... I also had the same error long ago, but forgot how i solved it.. Can you check this page phppgadmin.sourceforge.net/doku.php?id=faq#questions_on_dumps and see if anything works :) — Nandakumar V
– Nandakumar V, Commented Jun 2, 2015 at 16:36

Phani Kumar M · Accepted Answer · 2017-09-09 11:49:47Z

1

http://www.expertphp.in/article/postgres-phppgadmin-problem-empty-sql-dump-after-export

https://www.youtube.com/watch?v=L4W_6jnBXk0

Short: In /usr/share/phppgadmin/dbexport.php.

Change the line from : $cmd = $exe . " -i"; To `$cmd = $exe;

and then change passthru($cmd); To echo passthru($cmd);

edited Sep 9, 2017 at 11:49

Phani Kumar M

4,5781 gold badge16 silver badges26 bronze badges

answered Sep 9, 2017 at 11:25

Csaba Tóth

193 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

postgreSQL dump file generated when exporting is blank

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related