[postgis-users] From Debian to Windows + major upgrading of PostgreSQL and PostGIS

[Lee Hachadoorian]

On Thu, Jun 28, 2012 at 1:41 PM, Mathieu Basille
<basille at ase-research.org> wrote:
>
> I wonder whether the postgis_restore script would not alter the DB,
> especially since I still use an old PostGIS version where raster_columns was
> not yet a view... This is why it made sense to me to dump the whole DB again
> at the end of the process (to have a clean DB). But I might be wrong here.
>
> The main reason about starting the upgrade with Debian first is that I
> perfectly know how to restore the system (PostgreSQL/PostGIS + DB) in its
> current state with Debian. Which means that I can break it all, I will be
> able to come up with a functional system anyway (from a backup of the /main
> directory). I understand your point of view about switching OSes though.
> Still, I'm so much more familiar with Debian vs. Windows that I would rather
> lose some time in the upgrade process than running critical operations with
> Windows (i.e. upgrading PostGIS).


Ah, so the idea is that you need to accommodate changes in how PostGIS
stores things and feel more comfortable using Debian for that part of
the process. Makes sense. Need to do that myself to move from 1.5 to
2.0. Still think it makes sense to do the restore to a separate Debian
machine (which it sounds like you agree with) that can serve as an
fallback if the Windows install is problematic.

--Lee