X-Git-Url: https://git.argeo.org/?a=blobdiff_plain;f=org.argeo.maintenance%2Fsrc%2Forg%2Fargeo%2Fmaintenance%2Fbackup%2Fvfs%2FPostgreSqlBackup.java;fp=org.argeo.maintenance%2Fsrc%2Forg%2Fargeo%2Fmaintenance%2Fbackup%2Fvfs%2FPostgreSqlBackup.java;h=da3ea38b397bce34eb3ed579c6c6b4d8ada8ac13;hb=2980adcfb0c8778426cd0f2176b86ba00e9697ab;hp=0000000000000000000000000000000000000000;hpb=40af4cc6795ab669ec9432d1444f0779f9594952;p=lgpl%2Fargeo-commons.git

diff --git a/org.argeo.maintenance/src/org/argeo/maintenance/backup/vfs/PostgreSqlBackup.java b/org.argeo.maintenance/src/org/argeo/maintenance/backup/vfs/PostgreSqlBackup.java
new file mode 100644
index 000000000..da3ea38b3
--- /dev/null
+++ b/org.argeo.maintenance/src/org/argeo/maintenance/backup/vfs/PostgreSqlBackup.java
@@ -0,0 +1,85 @@
+/*
+ * Copyright (C) 2007-2012 Argeo GmbH
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ *         http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.argeo.maintenance.backup.vfs;
+
+import org.apache.commons.vfs2.FileObject;
+
+/** Backups a PostgreSQL database using pg_dump. */
+public class PostgreSqlBackup extends OsCallBackup {
+	/**
+	 * PostgreSQL password environment variable (see
+	 * http://stackoverflow.com/questions
+	 * /2893954/how-to-pass-in-password-to-pg-dump)
+	 */
+	protected final static String PGPASSWORD = "PGPASSWORD";
+
+	private String pgDumpLocation = "/usr/bin/pg_dump";
+
+	private String dbUser;
+	private String dbPassword;
+	private String dbName;
+
+	public PostgreSqlBackup() {
+		super();
+	}
+
+	public PostgreSqlBackup(String dbUser, String dbPassword, String dbName) {
+		this.dbUser = dbUser;
+		this.dbPassword = dbPassword;
+		this.dbName = dbName;
+		init();
+	}
+
+	@Override
+	public void init() {
+		// disable compression since pg_dump is used with -Fc option
+		setCompression(null);
+
+		if (getName() == null)
+			setName(dbName + ".pgdump");
+		super.init();
+	}
+
+	@Override
+	public void writeBackup(FileObject targetFo) {
+		if (getCommand() == null) {
+			getEnvironment().put(PGPASSWORD, dbPassword);
+			setCommand(pgDumpLocation + " -Fc" + " -U ${dbUser} ${dbName}");
+		}
+		getVariables().put("dbUser", dbUser);
+		getVariables().put("dbPassword", dbPassword);
+		getVariables().put("dbName", dbName);
+
+		super.writeBackup(targetFo);
+	}
+
+	public void setDbUser(String dbUser) {
+		this.dbUser = dbUser;
+	}
+
+	public void setDbPassword(String dbPassword) {
+		this.dbPassword = dbPassword;
+	}
+
+	public void setDbName(String dbName) {
+		this.dbName = dbName;
+	}
+
+	public void setPgDumpLocation(String mysqldumpLocation) {
+		this.pgDumpLocation = mysqldumpLocation;
+	}
+
+}