java - 使用java创建数据库备份postgresql

Question

这个问题已经有答案了:

FileNotFound Exception in Java (1 个回答)

已关闭 7 年前。

我尝试使用 Java 在 posgresql 中备份数据库，但是当我运行程序时，出现此错误:

Exception in thread "main" java.io.IOException: Cannot run program "pg_dump": CreateProcess error=2, specified file not found

这是我的代码

      String path = "C:\\Program Files (x86)\\PostgreSQL\\9.1\\bin\\pg_dump.exe";
Runtime r = Runtime.getRuntime();

//PostgreSQL variables    
String host = "localhost";
String user = "postgres";
String dbase = "GestionPharmacie";
String password = "*****";
Process p;
ProcessBuilder pb;


r = Runtime.getRuntime();        
pb = new ProcessBuilder("pg_dump", "-v", "-h", host, "-f", path, "-U", user, dbase);
pb.environment().put("PGPASSWORD", password);
pb.redirectErrorStream(true);
p = pb.start(); 

Answer 1

-D是一个无效选项，我设置了一个主机属性。

{
    String path = "D:\\aaa";
    Runtime r = Runtime.getRuntime();

    //PostgreSQL variables    
    String host = "localhost";
    String user = "postgres";
    String dbase = "GestionPharmacie";
    String password = "*****";
    Process p;
    ProcessBuilder pb;


    r = Runtime.getRuntime();        
    pb = new ProcessBuilder("pg_dump", "-v", "-h", host, "-f", path, "-U", user, dbase);
    pb.environment().put("PGPASSWORD", password);
    pb.redirectErrorStream(true);
    p = pb.start();        

} catch (Exception e) {