Re: Regarding pg_dump utility

On Thu, Jun 08, 2006 at 11:39:48AM +0530, soni de wrote:
> We have to take a backup of database and we know the pg_dump utility of
> postgresql.
>
> But may I know, is there any API for this pg_dump utility so that we can
> call it from the C program? Or only script support is possible for this.

It probably wouldn't be terribly difficult to put the guts of pg_dump
into a library that you could interface with via C. I'm not sure if the
community would accept such a patch; though, I seem to recall other
people asking for this on occasion.

> I think script support is bit risky because if anything goes wrong while
> taking backup using pg_dump then user will not understand the problem of
> falling
>
> If only script support is possible then what should we prefer perl or shell?

Depends on what you're trying to accomplish. Perl is a much more capable
language than shell, obviously.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461