I'd like to dump a postgresql database from my (java) app and copy the dump
file to the client machine.
This backup strategy prooved invalueable in the past (given enough room on
the harddrives, which I have) and I'd like to implement it now with
postgresql.
Is there something like a system stored procedure that does something like
that I can use? Calling pg_dump seems like a bad hack: I'd like to keep
communication at the java<->sql level if possible. I'll probably bare it,
but I'd like to check if I've missed something, first.
TIA,
Tomislav