On 7 July 2016 at 21:10, Robert Haas <robertmh...@gmail.com> wrote:
> pg_upgrade does that, kinda. I'd like to have something better, but
> in the absence of that, I think it's quite wrong to think about
> deprecating it, even if we had logical replication fully integrated
> into core today. Which we by no means do.
I don't see any problem with extending pg_upgrade to use logical
replication features under the covers.
It seems very smooth to be able to just say
and then specify whatever other parameters that requires.
It would be much easier to separate out that as a use-case so we can be
sure we get that in 10.0, even if nothing else lands.
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services