X-Original-To: pgsql-performance-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id C0E9A9FA3CD
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  8 Jun 2006 03:10:00 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 79379-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu,  8 Jun 2006 03:09:49 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from py-out-1112.google.com (py-out-1112.google.com
 [64.233.166.178])
	by postgresql.org (Postfix) with ESMTP id E39189FA5BA
	for <pgsql-performance@postgresql.org>;
	Thu,  8 Jun 2006 03:09:49 -0300 (ADT)
Received: by py-out-1112.google.com with SMTP id z74so444422pyg
	for <pgsql-performance@postgresql.org>;
	Wed, 07 Jun 2006 23:09:48 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=Hf0ac/s1CA9R1S4AKakNBXzs8bf+1jv+/fdiWjKTTtm6yyXQZb7TEwj/lwSOZYyAU2qtWsgrqRmsoaM9kI6s8DtufrXPVFYuPUuSdXRNWbxuysW7EuLm2OqI0xV8XyLbT///unTuVO+JUnAXSROZWbbkxkh94owHoM2Lb9TSeRA=
Received: by 10.35.99.5 with SMTP id b5mr1921287pym;
	Wed, 07 Jun 2006 23:09:48 -0700 (PDT)
Received: by 10.35.8.14 with HTTP; Wed, 7 Jun 2006 23:09:48 -0700 (PDT)
Message-ID: <9f2e40a90606072309v4c5b2623k8bda2614cd575835@mail.gmail.com>
Date: Thu, 8 Jun 2006 11:39:48 +0530
From: "soni de" <soni.de@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Regarding pg_dump utility
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_15766_6251708.1149746988718"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/84
X-Sequence-Number: 19441

------=_Part_15766_6251708.1149746988718
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello,



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.



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?



Please provide me some help regarding this



Thanks,

Soni

------=_Part_15766_6251708.1149746988718
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>&nbsp;</div>
<div>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hello,</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We have to take a backup of database and we know the pg_dump utility of postgresql.</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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.
</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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
</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">If only script support is possible then what should we prefer perl or shell?</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Please provide me some help regarding this</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks,</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Soni</span></p></div>

------=_Part_15766_6251708.1149746988718--