Re: Backup with Java

[Dave Cramer <pg(at)fastcrypt(dot)com>]

I'd strongly suggest you exec pg_dump from the command line using  
System.exec and connect to the remote database. This is certainly re- 
inventing a non-trivial wheel.

Dave
On 29-Nov-06, at 6:21 PM, tom12167 wrote:

> I would also like to use such a backup function by JDBC (for  
> backing up only one named database)
>
> tom
>
> Jim Nasby schrieb:
> > On Nov 27, 2006, at 12:20 PM, imad wrote:
> >
> > > Read and understand the file 'src/bin/pg_dump/pg_dump.c' in the  
> > > postgresql
> > > core server code base. This is the only solution of your problem,  
> > > you are going
> > > to rewrite all the C code in JAVA.
> >
> > BTW, if you're going to go to that much trouble, you should ask on  
> > -hackers about putting some of the pg_dump functionality into  
> > functions, since this isn't the first time people have asked for a  
> > non-pg_dump backup solution. It would make sense to abstract  
> > things that were reasonable out of pg_dump and into the database  
> > itself if there's really that much demand for this.
> >
> > Another option would be providing some means to call pg_dump(all)  
> > from a database connection.
> > --
> > Jim Nasby                                            jim(at)nasby(dot)net
> > EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)
> >
> >
> >
> > ---------------------------(end of  
> > broadcast)---------------------------
> > TIP 5: don't forget to increase your free space map settings
>
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org