Re: Backup with Java

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@nasby.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
>