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@pgadmin.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@yahoo.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
>
