Restore Postgresql Database in C#

Question

I created a . bat to restore a database in Postgresql and it worked perfectly using the following command:

set PGPASSWORD=postgres123

C:\Progra~1\PostgreSQL\9.4\bin\pg_restore.exe -i -h localhost -p 5432
-U postgres -c -d dbrestore -v D:\bkp.backup

Now I want to run a bat to do this in C#. I’m running this function:

static void Restore()
{
  Environment.SetEnvironmentVariable("PGPASSWORD", clsConfigBanco.PASSWORD);
  const string exe = @"C:\Progra~1\PostgreSQL\9.4\bin\pg_restore.exe";
  const string arg = "-i - h localhost - p 5432 - U postgres - c - d dbrestore - v D:\bkp.backup";

  ProcessStartInfo startInfo = new ProcessStartInfo();
  startInfo.FileName = exe;
  startInfo.Arguments = arg;

  try
  {
      using (Process exeProcess = Process.Start(startInfo))
      {
          exeProcess.WaitForExit();
      }
  }
  catch
  {
       // Log error.
  }
}

The problem is that this function doesn’t even run the bat. it just blinks and disappears. how do I make a function to run this bat? and I have to generate it at runtime because not always the variables will be the same

Answer 1

In the following line:

const string arg = "-i - h localhost - p 5432 - U postgres - c - d dbrestore - v D:\bkp.backup";

was not placed @ before the string, which causes \ is a special character and the compiler did not present an error because \b is a special character.

You can solve this by putting the @ before the string, or using \\ in place of \

You also have to take the using:

Follows code:

static void Restore()
{
  Environment.SetEnvironmentVariable("PGPASSWORD", clsConfigBanco.PASSWORD);
  const string exe = @"C:\Progra~1\PostgreSQL\9.4\bin\pg_restore.exe";
  const string arg = @"-i - h localhost - p 5432 - U postgres - c - d dbrestore - v D:\bkp.backup";

  ProcessStartInfo startInfo = new ProcessStartInfo();
  startInfo.FileName = exe;
  startInfo.Arguments = arg;

  try
  {
      Process exeProcess = Process.Start(startInfo);
      exeProcess.WaitForExit();
  }
  catch
  {
       // Log error.
  }
}

as I posted in another question, I use the psql to run Restore. Here, I made the following code and it works perfectly:

        Environment.SetEnvironmentVariable("PGPASSWORD", senha);
        const string exe = @"C:\Progra~2\PostgreSQL\9.1\bin\psql";
        const string arg = @"-U postgres -d db_banco -f D:\Backup\postgresql.dumpall";

        ProcessStartInfo startInfo = new ProcessStartInfo();
        startInfo.FileName = exe;
        startInfo.Arguments = arg;

        Process exeProcess = Process.Start(startInfo);

        exeProcess.WaitForExit();