Pg_dump.exe is not running using system.diagnostics.process

Question

1.00/5 (2 votes)

See more:

I want to store locally my Postgres database (.backup) using Winform C#.

What I have tried:

C#

string cmd = "-i -h localhost -p 5432 
-U postgres -F c -b -v -f " + "@D:\\DatabaseBackupGrabberDaily\\" + 
"iis_live" + ".backup ";

System.Diagnostics.ProcessStartInfo info = new System.Diagnostics.ProcessStartInfo();
                info.FileName = @"C:\ProgramFiles\PostgreSQL\9.6\bin\pg_dump.exe";
                info.Arguments = cmd;
                info.CreateNoWindow = true;
                info.UseShellExecute = false;
                System.Diagnostics.Process proc = 
                         new System.Diagnostics.Process();
                proc.StartInfo = info;
                proc.Start();                
                proc.WaitForExit();

Posted 23-Aug-23 22:09pm

odimaxxx

Updated 14-Sep-23 2:29am

Deeksha Shenoy

v3

Add a Solution

Comments

Richard MacCutchan 24-Aug-23 5:10am

Change true to false in the line:

info.CreateNoWindow = true;

and you may be able to see what is going wrong.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2023-08-23T22:16:00

We can't tell: we have no access to your system to see what might be going on - and your command requires files in specific places which may not be valid for anyone else's PC.

So it's going to be up to you - I'd start by removing this line:

info.CreateNoWindow = true;

And seeing what happens on the console when it tries
If you can't see anything there, then redirect the output and error streams of the process to either a stream in your app or a file and see if you can see any error messages there.

You need to get error (or otherwise) messages before you can even begin to diagnose the problem, and we really can't do any of that for you!

Dave Kreskowiak · Answer 2 · 2023-09-14T03:03:00

Solution 2

It's because you're Filename path is wrong. There should be a space between "Program" and "Files".

C#

info.FileName = @"C:\Program Files\PostgreSQL\9.6\bin\pg_dump.exe";
                            ^

Posted 14-Sep-23 3:03am

Dave Kreskowiak