Re: Regarding pg_dump utility - Mailing list pgsql-performance

From Paul S
Subject Re: Regarding pg_dump utility
Date
Msg-id 866624ef0606090722n3779b835l316035b2a04b75e1@mail.gmail.com
Whole thread Raw
In response to Re: Regarding pg_dump utility  (Christopher Kings-Lynne <chris.kings-lynne@calorieking.com>)
List pgsql-performance
I think that having an API for backup functionality would definitely be useful. 
 
Just my 2 cents...
 
Paul
 


 
On 6/8/06, Christopher Kings-Lynne <chris.kings-lynne@calorieking.com> 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.

What about fully completing our SQL API for dumping?

ie. We finish adding pg_get_blahdef() for all objects, add a function
that returns the proper ordering of all objects in the database, and
then somehow drop out a dump with a single JOIN :D

Chris


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

pgsql-performance by date:

Previous
From: "Domenico - Sal. F.lli Riva"
Date:
Subject: pgsql_tmp and postgres settings
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Why date index is not used