Re: Re : Feature request: pgdump and version number / -i option

["Sufficool, Stanley" <ssufficool(at)rov(dot)sbcounty(dot)gov>]

If we can get these tools as libraries with exported functions, then
wouldn't just be a matter of some UDF calling the C libraries? 

It would be ideal to get this absorbed into the mainline PG development,
but proof that it works and has a userbase would go a long way towards
acceptance.

As I noted in my first post, I am very aware that this could break
client side backups. Your idea of streaming the backup is something I
hadn't considered. If the stream was compressed, then this would
actually reduce backup times at the client!

Should I join and cross post to pg-hackers to bring them into the fray?


> -----Original Message-----
> From: Dave Page [mailto:dpage(at)pgadmin(dot)org] 
> Sent: Monday, January 12, 2009 6:41 AM
> To: Laurent ROCHE
> Cc: Sufficool, Stanley; pgAdmin III support
> Subject: Re: Re : [pgadmin-support] Feature request: pgdump 
> and version number / -i option
> 
> 
> On Mon, Jan 12, 2009 at 2:35 PM, Laurent ROCHE 
> <laurent_roche(at)yahoo(dot)com> wrote:
> > Still in my case (I assume other people too) pl/pgsql 
> functions would 
> > not help as I work on a remote server from a workstation: I 
> want the 
> > files on my workstation and not on a remote server that I 
> only access 
> > for the database !
> 
> Presumably we'd be able to stream the output in a similar way to COPY.
> 
> In any case, there would have to still be a pg_dump style 
> interface so it could be used to dump from old server without 
> needing a whole new server. I would expect any server 
> functions to simply be wrappers around a llibrary of 
> functions used by pg_dump. Not that this is the right place 
> or I the right person to be discussing this!!
> 
> -- 
> Dave Page
> EnterpriseDB UK:   http://www.enterprisedb.com
>