Aplicación Java para copias de seguridad programadas de PostgreSQL usando pg_dump (Sólo Windows)

import java.io.*;
import java.text.SimpleDateFormat;
import java.util.*;

public class PostgreSQLBackup {

  public void backupPGSQL() {
    try {
      // Define paths and PostgreSQL details
      String backupDirPath = "C:\\BACKUPS\\";
      String pgDumpPath = "C:\\Program Files\\PostgreSQL\\bin\\pg_dump.exe";
      //PostgreSQL variables
      String ip = "192.168.1.1";
      String user = "postgres";
      String database = "yourDatabase";
      String password = "yourPassword";

      // Generate filename with today’s date
      SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMdd");
      String date = dateFormat.format(new Date());
      String backupFile = backupDirPath + date + ".backup";

      // Ensure the backup directory exists
      File backupDir = new File(backupDirPath);
      if (!backupDir.exists() && !backupDir.mkdirs()) {
          throw new IOException("Could not create backup directory: " + backupDirPath);
      }

      // Delete any previous backup that might exist
      File backup = new File(backupFile);
      if (backup.exists()) {
          backup.delete();
      }

      // Configure ProcessBuilder for pg_dump
      ProcessBuilder pb = new ProcessBuilder(
          pgDumpPath,
          "-f", backupFile,
          "-F", "c",
          "-Z", "9",
          "-v",
          "-h", ip,
          "-U", user,
          database
      );
      pb.environment().put("PGPASSWORD", password);
      pb.redirectErrorStream(true);

      // Start the process and capture output
      Process process = pb.start();
      BufferedReader reader = new BufferedReader(new InputStreamReader(process.getInputStream()));
      try {
        String line;
        while ((line = reader.readLine()) != null) {
          System.out.println(line);
        }
      } finally {
          reader.close();
      }

      // Wait for process to complete
      int exitCode = process.waitFor();
      if (exitCode != 0) {
          throw new RuntimeException("pg_dump failed with exit code: " + exitCode);
      }

      System.out.println("Backup completed successfully: " + backupFile);
    } catch (Exception e) {
      e.printStackTrace();
    }

  }
  public static void main(String[] args) {
    new PostgreSQLBackup().backupPGSQL();
  }
}

import java.util.*;

public class ScheduledBackup {
  public static void main(String[] args) {
    TimerTask backupTask = new TimerTask() {
        @Override
        public void run() {
            new PostgreSQLBackup().backupPGSQL();
        }
    };

    // Schedule the task to run every 24 hours (at 1:00 AM)
    Timer timer = new Timer();
    Calendar taskTime = Calendar.getInstance();
    taskTime.set(Calendar.HOUR_OF_DAY, 1);
    taskTime.set(Calendar.MINUTE, 0);
    taskTime.set(Calendar.SECOND, 0);

    // Adjust start time if it's already past the initial scheduled time
    if (new Date().after(taskTime.getTime())) {
        taskTime.add(Calendar.DAY_OF_YEAR, 1);
    }

    timer.scheduleAtFixedRate(backupTask, taskTime.getTime(), 1000L * 60 * 60 * 24);
    System.out.println("Scheduled backup task set for 1:00 AM daily.");
  }
}