Postgres backup

From: "pd" <petedawn(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres backup
Date: 2006-10-02 04:20:12
Message-ID: 1159762812.810912.111310@m73g2000cwd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

guys,

i have a java web app with a postgres backend. now i want to implement
a db database functionality from within my web app. now i have got
this so far,

String[] args = {"\"C:\\Program
Files\\PostgreSQL\\8.1\\bin\\pg_dump\"", " -i", " -h", " localhost", "
-p", " 5432", " -U", " postgres", " -F", " t", " -b", " -v", " -f", "
\"C:\\Test.backup\"", " TESTDB"};

String result = "";
if (args.length > 0) {
result = args[0]; // start with the first element
for (int i=1; i<args.length; i++) {
result = result + args[i];
}
}

Process p = Runtime.getRuntime().exec(result);

Now on executing this i am getting a file called Test.backup, but its
0KB compeletely empty. can somebody tell me what i am doing wrong and
how can i fix it. somebody also told me that this is not the best way
of doing this, and i was wondering is there a better way of
implementhing this.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wyatt Tellis 2006-10-02 04:47:21 Re: Cause of ERROR: could not open relation
Previous Message Brendan Jurd 2006-10-02 03:13:58 ISO week dates