Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. "DataConnection": {
  2. "Servidor": "localhost",
  3. "Porta": "5432",
  4. "Usuario": "postgres",
  5. "Senha": "334522",
  6. "NomeBancoDados": "Retaguarda",
  7. "DiretorioComando": "C:\Program Files\PostgreSQL\11\bin",
  8. "DiretorioBackup": "C:\Users\JALBER\Downloads\",
  9. "NomeArquivo": "Backup_Retaguarda_"
  10. }
  11.  
  12. public void CreateBackup(BackupRestore backupRestore)
  13. {
  14. Environment.SetEnvironmentVariable("PGPASSWORD", backupRestore.Senha);
  15.  
  16. string backupFile = backupRestore.DiretorioBackup + backupRestore.NomeArquivo + DateTime.Now.ToString("yyyy") + "_" + DateTime.Now.ToString("MM") + "_" + DateTime.Now.ToString("dd") + ".backup";
  17. string BackupString = "-ibv -Z3 -f "" + backupFile + "" " +
  18. "-Fc -h " + backupRestore.Servidor + " -U " + backupRestore.Usuario + " -p " + backupRestore.Porta + " " + backupRestore.NomeBancoDados;
  19.  
  20. Process proc = new System.Diagnostics.Process();
  21. proc.StartInfo.FileName = backupRestore.DiretorioComando + "\pg_dump.exe";
  22. proc.StartInfo.Arguments = BackupString;
  23.  
  24. proc.Start();
  25. proc.WaitForExit();
  26. proc.Close();
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement