Dave Smith <dave(dot)smith(at)candata(dot)com> writes:
> Why not go the other way.
> 1) Dump the schemas.
> 2) Initdb with the new schemas in a tmp PGDATA
> 3) backup the schemas in the current PGDATA
> 4) move the new schemas from the new db into the current one.
This seems like approximately the same thing except you lose the
property of not having modified the old DB if you fail partway through.
What's the advantage exactly?
> This means that doing an update you would only have to have space for
> the system catalogs not the whole database.
That's true either way.
regards, tom lane