pg_dump from Java or SQL?

Поиск
Список
Период
Сортировка
От Jason Long
Тема pg_dump from Java or SQL?
Дата
Msg-id 20051202215419.744439DCAD7@postgresql.org
обсуждение исходный текст
Список pgsql-general

Is it possible to access backup and restore functionality from SQL or Java?  I am attempting to allow some this functionality from a webapp.

 

The best I have so far is the following Java code.

 

  Runtime runtime = Runtime.getRuntime();

  String[] cmd = { "cmd",

                             "/c",

                             "C:/PostgreSQL/8.0/pgAdmin_III/pg_dump.exe -i -h localhost -p 5432 -U postgres -F c -b -v -f C:/"

                             +(new Date()).getTime()

                             +".backup mydatabase" };

  Process p = runtime.exec(cmd);

 

Thank you for your time,

 

Jason Long

CEO and Chief Software Engineer

BS Physics, MS Chemical Engineering

http://www.supernovasoftware.com

 

В списке pgsql-general по дате отправления:

Предыдущее
От: "Karl O. Pinc"
Дата:
Сообщение: New.* and old.* as function arguments within rules
Следующее
От: Tony Caduto
Дата:
Сообщение: was a initdb required from 8.1beta3 -> beta4?