Re: Backup with Java

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(dot)taruffi(at)ricesoft(dot)it <tommaso(dot)taruffi(at)ricesoft(dot)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
>