Problems restoring a Postgresql database with C#

Question

private void btnRestore_Click(object sender, EventArgs e)
{
    if (clsB.ConectaBanco())
    {
        //Executo a seguinte função para limpar a base de dados, para poder dar o restore.
        clsB.ExecutarSQL("drop schema public cascade; create schema public;");

        //E executo o seguinte processo
        string Comando = CaminhoPg + @"psql -U postgres -d restore2 -f C:\Users\bruhh\Desktop\Backup\back.backup";

        Process p = new System.Diagnostics.Process();
        p.StartInfo.FileName = CaminhoPg + @"psql" ;
        p.StartInfo.Arguments = @"-U postgres -d restore2 -f C:\Users\bruhh\Desktop\Backup\back.backup";

        p.Start();

        p.WaitForExit();
        p.Close();

        MessageBox.Show(Comando);
    }
    else
        MessageBox.Show("Ocorreu um erro ao carregar as configurações do banco de dados! \nvá em Configurações\\Banco De Dados");
}

The result of the variable command is

C:\\Program Files\\PostgreSQL\\9.4\\bin\\psql -U postgres -d restore2 -f C:\\Users\\bruhh\\Desktop\\Backup\\back.backup

The process even runs but on all lines appears "invalid command". What would be necessary to make this code work?

How the process looks when it is executed

[EDIT] Method used to perform Backup

public string BackupDatabase(string CaminhoNome)
{
    string server = clsConfigBanco.SERVERNAME;
    string port = clsConfigBanco.PORT;
    string user = clsConfigBanco.USERNAME;
    string password = clsConfigBanco.PASSWORD;
    string dbname = clsConfigBanco.DATABASENAME;
    string backupCommandDir = @"C:\Program Files\PostgreSQL\9.4\bin";
    try
    {
       Environment.SetEnvironmentVariable("PGPASSWORD", password);

       string backupFile = CaminhoNome;
       string BackupString = "-ibv -Z3 -f \"" + backupFile + "\" " +
                "-Fc -h " + server + " -U " + user + " -p " + port + " " + dbname;

       Process p = new System.Diagnostics.Process();
       p.StartInfo.FileName = CaminhoPg + "\\pg_dump.exe";
       p.StartInfo.Arguments = BackupString;

       p.Start();

       p.WaitForExit();
       p.Close();

       return backupFile;
   }
   catch
   {
      return "";
    }


 }

Answer 1

I believe you’re using the Process.Start wrong way. See the example:

static void LaunchCommandLineApp()
{
    // For the example.
    const string exe = "C:\\Program Files\\PostgreSQL\\9.4\\bin\\psql";
    const string arg = "-U postgres -d restore2 -f C:\\Users\\bruhh\\Desktop\\Backup\\back.backup";

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

    try
    {
        // Start the process with the info we specified.
        // Call WaitForExit and then the using-statement will close.
        using (Process exeProcess = Process.Start(startInfo))
        {
            exeProcess.WaitForExit();
        }
    }
    catch
    {
        // Log error.
    }
}

I removed the example of this site: https://www.dotnetperls.com/process

other than that, apparently I didn’t find anything wrong. If possible, put more information, how is the dump and the error messages that appear.