On Thu, Sep 2, 2010 at 6:41 PM, Dimitri Fontaine <dfonta...@hi-media.com> wrote: > In fact you don't need shell access here, it's rather easy to stream the > base backup from the libpq connection, as implemented here : > > http://github.com/dimitri/pg_basebackup > >> There's been some talk of being able to stream a base backup over the >> replication connection too, which would be extremely handy. > > Yes please ! :)
One issue of the base backup function is that the operation will be a long transaction. So, non-transactional special commands, as like as VACUUM, would be better in terms of performance. For example, CREATE or ALTER REPLICATION. Of course, function-based approach is more flexible and less invasive to the SQL parser. There are trade-offs. -- Itagaki Takahiro -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
