[postgis-users] postgresql upgrade from 8.4 to 9.1

[Martin Landa]

Hi,

2013/11/5 Sandro Santilli <strk at keybit.net>:

> You're likely restoring postgis objects togheter with the data.
> The postgis objects in the old database are meant to be used
> with PostgreSQL 8.4, not 9.1. You need to skip those objects.
>
> The postgis_restore.pl script was written to do the objects
> skip for you, at restore time.
>
> By using pg_upgradecluster you're missing the "skip" step
> in the process. You'll have to do the pg_dump/pg_restore manually
> instead, as documented in the "Hard Upgrade" section in the manual.

right, thanks! Martin

-- 
Martin Landa <landa.martin gmail.com> * http://geo.fsv.cvut.cz/~landa