Message-ID: <44885158.9020209@pse-consulting.de>
Date: Thu, 08 Jun 2006 18:33:28 +0200
From: Andreas Pflug <pgadmin@pse-consulting.de>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
MIME-Version: 1.0
To: Alvaro Herrera <alvherre@commandprompt.com>
CC: "Jim C. Nasby" <jnasby@pervasive.com>, soni de <soni.de@gmail.com>,
	pgsql-performance@postgresql.org
Subject: Re: Regarding pg_dump utility
References: <9f2e40a90606072309v4c5b2623k8bda2614cd575835@mail.gmail.com>
	<20060608151657.GL45331@pervasive.com>
	<20060608162327.GD17421@surnet.cl>
In-Reply-To: <20060608162327.GD17421@surnet.cl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Alvaro Herrera wrote:

> 
> 
> Personally I think it would be neat.  For example the admin-tool guys
> would be able to get a dump without invoking an external program.
> Second it would really be independent of core releases (other than being
> tied to the output format.)  pg_dump would be just a simple caller of
> such a library, and anyone else would be able to get dumps easily, in
> whatever format.

pgAdmin currently invokes pg_dump/restore externally with pipes attached 
to stdin/out/err, but a library implementation would solve some 
headaches (esp. concerning portability) managing background 
execution/GUI updates/process control. I'd like a libpgdumprestore 
library, with pg_dump/pg_restore being lean wrapper programs.

Regards,
Andreas