Re: Backup and restore through JDBC - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: Backup and restore through JDBC
Date
Msg-id 451D18AD.4000206@pse-consulting.de
Whole thread Raw
In response to Re: Backup and restore through JDBC  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Backup and restore through JDBC  ("Marlon Petry" <marlonpetry@gmail.com>)
List pgsql-hackers
Andrew Dunstan wrote:
> Marlon Petry wrote:
>>
>>
>>     pg_dump and pg_restore do not need to run on the server machine.
>>     Why not
>>     just run them where you want the dump stored?
>>
>>
>>
>>
>> But I would need to have installed pg_dump and pg_restore in machine
>> client?
>> Without having installed pg_dump and pg_restore,how I could make
>>
>>
>
>
> You can't. pg_dump in particular embodies an enormous amount of
> knowledge that simply does not exist elsewhere. There is no
> dump/restore API, and there is nothing you can hook up to using JNI,
> AFAIK.
Recently, there was the proposal to extract that knowledge to a library
(making pg_dump itself just a wrapper). This sounds valuable more and
more, is anybody working on this for 8.3?

Regards,
Andreas



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Block B-Tree concept
Next
From: Markus Schaber
Date:
Subject: Re: Backup and restore through JDBC