Re: Postgres backup

On 10/3/06, Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
> On Sun, Oct 01, 2006 at 09:20:12PM -0700, pd wrote:
> > guys,
> >
> > i have a java web app with a postgres backend. now i want to implement
> > a db database functionality from within my web app. now i have got
> > this so far,
> >
> > String[] args = {"\"C:\\Program
> > Files\\PostgreSQL\\8.1\\bin\\pg_dump\"", " -i", " -h", " localhost", "
> > -p", " 5432", " -U", " postgres", " -F", " t", " -b", " -v", " -f", "
> > \"C:\\Test.backup\"", " TESTDB"};
>

> Secondly, work out where your STDERR is going, because any error
> messages from pg_dump will have gone there...

For some useful info on draining STDERR (and seeing error codes etc)
from with java see
http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html
-Damian