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:dp...@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_ro...@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 > -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
