Java App for PostgreSQL scheduled backups using pg_dump (Windows only)

1public void backupPGSQL(){
2  try{
3    Runtime r =Runtime.getRuntime();
4    //Path to the place we store our backup
5    String rutaCT = "C:\\BAKCUPS\\";
6    //PostgreSQL variables
7    String IP = "192.168.1.1";
8    String user = "postgres";
9    String dbase = "yourDataBase";
10    String password = "yourPassword";
11    Process p;
12    ProcessBuilder pb;
13    InputStreamReader reader;
14    BufferedReader buf_reader;
15    String line;
16    //We build a string with today's date (This will be the backup's filename)
17    java.util.TimeZone zonah = java.util.TimeZone.getTimeZone("GMT+1");
18    java.util.Calendar Calendario = java.util.GregorianCalendar.getInstance( zonah, new java.util.Locale("es"));
19    java.text.SimpleDateFormat df = new java.text.SimpleDateFormat("yyyyMMdd");
20    StringBuffer date = new StringBuffer();
21    date.append(df.format(Calendario.getTime()));
22    java.io.File file = new java.io.File(rutaCT);
23    // We test if the path to our programs exists
24    if (file.exists()) {
25      // We then test if the file we're going to generate exist too. If so we will delete it
26      StringBuffer fechafile = new StringBuffer();
27      fechafile.append(rutaCT);
28      fechafile.append(date.toString());
29      fechafile.append(".backup");
30      java.io.File ficherofile = new java.io.File(fechafile.toString());
31      if (ficherofile.exists()) {
32        ficherofile.delete();
33      }
34      r = Runtime.getRuntime();
35      pb = new ProcessBuilder(rutaCT + "pg_dump.exe", "-f", fechafile.toString(),
36          "-F", "c", "-Z", "9", "-v", "-o", "-h",IP, "-U", user, dbase);
37      pb.environment().put("PGPASSWORD", password);
38      pb.redirectErrorStream(true);
39      p = pb.start();
40      try {
41        InputStream is = p.getInputStream();
42        InputStreamReader isr = new InputStreamReader(is);
43        BufferedReader br = new BufferedReader(isr);
44        String ll;
45        while ((ll = br.readLine()) != null) {
46          System.out.println(ll);
47        }
48      } catch (IOException e) {
49        log("ERROR "+e.getMessage(), e);
50      }
51    }
52  } catch(IOException x) {
53    System.err.println("Could not invoke browser, command=");
54    System.err.println("Caught: " + x.getMessage());
55  }
56}

1TimerTask backupTask = new TimerTask() {
2  public void run(){
3    backupPGSQL();
4  }
5};
6// We schedule the task to be run every 24 hours
7Timer time = new Timer();
8time.scheduleAtFixedRate(backupTask, new Date(),1000*60*60*24);
9// Even better, we can schedule the task to be run every 24 hours at a fixed time.
10// (remember to remove the above line if you prefer this method)
11Calendar taskTime = Calendar.getInstance();
12// We want the task to be run at 1 o'clock in the morning
13taskTime.set(Calendar.HOUR_OF_DAY, 1);
14// We clear the rest of the values for the calendar
15taskTime.clear(Calendar.MINUTE);
16taskTime.clear(Calendar.SECOND);
17taskTime.clear(Calendar.MILLISECOND);
18// If the time has already passed, we add another day to the count, so the task will start tomorrow
19if (now.after(taskTime)) {
20  taskTime.add(Calendar.DAY_OF_YEAR, 1);
21}
22Date startingDate = taskTime.getTime();
23time.scheduleAtFixedRate(backupTask, startingDate, 1000L*60*60*24);