Skip site navigation (1) Skip section navigation (2)

Re: Backup and restore through JDBC

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Marlon Petry <marlonpetry(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Backup and restore through JDBC
Date: 2006-09-29 12:59:25
Message-ID: 451D18AD.4000206@pse-consulting.de (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-hackers by date

Next:From: Markus SchaberDate: 2006-09-29 13:12:24
Subject: Re: Backup and restore through JDBC
Previous:From: Gregory StarkDate: 2006-09-29 12:59:09
Subject: Re: Block B-Tree concept

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group