Re: Backup with Java

On 30-Nov-06, at 7:37 AM, Patric Bechtel wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Marc,
>
> Marc Herbert schrieb am 30.11.2006 12:03:
>> Dave Cramer <pg(at)fastcrypt(dot)com> writes:
>>
>>> 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.
>>
>> We have implemented this, with a couple of additional checks
>>
>> <https://forge.continuent.org/plugins/scmcvs/cvsweb.php/sequoia/
>> src/org/continuent/sequoia/controller/backup/?cvsroot=sequoia>
>>
>> This code is generic, designed to support not only PostgreSQL.
>>
>> We could try to externalize it into an independent project if a
>> significant number of people are interested and... provided it's not
>> too hard to detach it from sequoia (no promise here).
>>
>> We also interested by alternatives approaches.
>
> I'm following the discussion for quite a while already... very
> interesting topic.
> But I just checked the link above, and it's still native. It's just a
> wrapper around pg_dump and even psql for single SQL statements...
>
Yes, and given the complexity of this plus the requirement to keep up
with each new server version;
unless this facility is built in to the server I would suggest this
is the only sane way to go.
> - --
> Mit freundlichen Gruessen / Regards
> Patric Bechtel, IPCON Informationssysteme OHG
> Kontakt: http://www.ipcon.de/kontakt.php
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.3 (GNU/Linux)
> Comment: GnuPT 2.5.2
>
> iD8DBQFFbtCOfGgGu8y7ypARAm4lAKDT1uKP5Md4E2dyOENZ6IEG2TJugQCg5vzp
> +Qnr7dpMsQffBbNp7Q8dQ4g=
> =nV7z
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>