Postgres pg_dump show empty file

Question

I am using this command in wamp, but I am getting empty Mybackup.sql file, did my knows what I am missing?

<?php    exec("pg_dump -U postgres taro-api > Mybackup.sql"); ?>

How do you authenticate to postgres server? Are you running this code as an unix user, who has the privilege to connect to postgres server as an user postgres? — Petr
– Petr, Commented Jan 16, 2019 at 12:49
I am executing this through wamp in window machine, please note I am running pg_queries with ease. — Kamran Sohail
– Kamran Sohail, Commented Jan 16, 2019 at 13:17
You command probably causes an error, that's why nothing is written. — Laurenz Albe
– Laurenz Albe, Commented Jan 16, 2019 at 13:35
Append 2>&1 to the command, then the error message will be added to the output. That should help. Perhaps pg_dump is not on the PATH. — Laurenz Albe
– Laurenz Albe, Commented Jan 16, 2019 at 15:38

Laurenz Albe · Accepted Answer · 2019-01-17 06:52:20Z

1

With the additional information from the comments, it becomes clear that you are on Windows and pg_dump is not on your PATH.

Either use the full absolute path for pg_dump or add the directory to the PATH environment variable.

answered Jan 17, 2019 at 6:52

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

10 Comments

Kamran Sohail Over a year ago

you are helping me alot, can you give me favor that how can I set this? pg_dump is located here, C:\Program Files\PostgreSQL\10\bin, but I want whenever I go live I don't face same issue.

Laurenz Albe Over a year ago

Then use \"C:\\Program Files\\PostgreSQL\\10\\bin\\pg_dump\" -U postgres -d taro-api -f Mybackup.sql.

Kamran Sohail Over a year ago

print_r(exec('\"C:\\Program Files\\PostgreSQL\\10\\bin\\pg_dump\" -U postgres -d taro-api -f 2>&1 Mybackup.sql')); response message "operable program or batch file." this empty .sql is not created as well

Laurenz Albe Over a year ago

If you use single quotesnfor the exec argument, do away with the backslashes escaping the double quotes.

Laurenz Albe Over a year ago

This is the only way to make a logical backup. By the way, you messed up the command. It should be exec('"C:\\Program Files\\PostgreSQL\\10\\bin\\pg_dump" -U postgres -d taro-api -f Mybackup.sql 2>&1').

|

Collectives™ on Stack Overflow

Postgres pg_dump show empty file

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related