On Sat, Aug 11, 2012 at 01:48:13AM +0200, Dimitri Fontaine wrote:
>
> >> Another thing worth considering is to have pg_upgrade init, stop and
> >> start clusters as necessary instead of requesting the user to do it.
> >> I think this is two less steps.
> >
> > Then you'd need to expose the entire pg_ctl shutdown mode logic through pg_upgrade, which might not make things
simpler.
>
> What about having single user mode talk fe/be protocol, and talk to it via a UNIX pipe, with pg_upgrade starting the
singleuser backend as a subprocess?
You still need to run libpq applications, so would be doing some process
juggling to get the libpq clients to talk to a pipe.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +