How to take PostgreSQL database backup using Java

Question

I want to use a PostgreSQL db for backup using java. I've tried with the below code but I am getting:

error pg_dump: too many command-line arguments (first is " postgres") Try "pg_dump --help" for more information.

Runtime r = Runtime.getRuntime();
Process p;
ProcessBuilder pb;
r = Runtime.getRuntime();
pb = new ProcessBuilder( 
        "/usr/pgsql-9.3/bin/pg_dump",
        "--host", "localhost",
        "--port", "5432",
        "--username", "postgres",
        "--dbname", "postfixdb",
        "--role", "postgres",
        "--password"," postgres",
        "--verbose",
       "/usr/pg_dump.backup");
pb.redirectErrorStream(true);
p = pb.start();
InputStream is = p.getInputStream();
InputStreamReader isr = new InputStreamReader(is);
BufferedReader br = new BufferedReader(isr);
String ll;
while ((ll = br.readLine()) != null) { System.out.println(ll); }

Laurenz Albe · Accepted Answer · 2017-06-05 09:51:28Z

1

Consult the psql documentation for the invocation syntax and a list of allowed options.

Try to run it on the command line first, and only when that succeeds, try to run it from Java.

A list ob obvious mistakes:

The option for “user” is -U (capitalized).
-p is for the TCP port number.
There is no -B option.
There is no -r option.

answered Jun 5, 2017 at 9:51

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user4383047 Over a year ago

I tryed this same code in windos for mysql, in their this code is working but here not. these both having different syntax?

Laurenz Albe Over a year ago

Yes, because they are different programs. MySQL is not the same as PostgreSQL.

user4383047 Over a year ago

Bro, I tryed this new code here creating backup file but empty and line reader not executing. only upto "aaaa" printing in console.

Collectives™ on Stack Overflow

How to take PostgreSQL database backup using Java

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related