Re: Backup with Java

2006/11/30, Dave Cramer <pg(at)fastcrypt(dot)com>:

> That could certainly be changed much easier than duplicating the
> entire pg_dump functionality

Yeah, but the way this have been architected, it's impossible to do a
backup over the network, i.e. with only the 5432 port at your
disposal. And that's just one of the _obvious_ drawbacks...the way I
see it, the way to do it would be to move the dump code into the
database server. Let _the_server_ do all the hard work and let the
application on the other end do whatever it wants with the (supposedly
plain text) dump. That's flexibility, and it wouldn't require
rewriting the dump utility - just a move into the server itself.

t.n.a.