Re: Backup with Java
От | Aaron Mulder |
---|---|
Тема | Re: Backup with Java |
Дата | |
Msg-id | 74e15baa0611301707m413453ddhc3b7584c4f5dbf3a@mail.gmail.com обсуждение исходный текст |
Ответ на | Backup with Java ("tommaso.taruffi@ricesoft.it" <tommaso.taruffi@ricesoft.it>) |
Список | pgsql-jdbc |
Seems like a hybrid approach may be the most practical. If you dump the DDL rarely (or whenever it changes) with pg_dump or a similar DB-specific tool, then you could probably generate a frequent data backup fairly easily with pure JDBC code. The only trick on the restore would be to do it in an order consistent with the keys, and again, you ought to be able to determine that via JDBC (or perhaps determine that it's not possible, in which case maybe you manually insert some statements to suspend RI during the import or whatever). Thanks, Aaron On 11/27/06, tommaso.taruffi@ricesoft.it <tommaso.taruffi@ricesoft.it> wrote: > Hello, > I have a question about how I can make a database backup > with Java. I have made a class Connection.java that connect > my application with Postgresql Database. I would make a > function in this class for backup the state of the database. > Anyone can help me? > > Thanks! > Dr. Tommaso Taruffi > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate >
В списке pgsql-jdbc по дате отправления: