[postgis-users] Upgrading from 1.5

[Paul Ramsey]

Nope, your version is so very old that you’ll have to do some work on it. You’re going to have to dump your database, filter out the postgis-specific parts, and then reload it into your new database, the so-called “hard upgrade” process: http://postgis.net/docs/postgis_installation.html#hard_upgrade <http://postgis.net/docs/postgis_installation.html#hard_upgrade>

If your database isn’t too large it won’t be too onerous. And you can do it in “one step”, in that the process is: dump, filter dump file, install brand new software, load filtered dump file. No need to traverse intermediate versions or anything fiddly like that.

ATB,

P


> On Aug 13, 2019, at 8:39 AM, Dara Unglaube <dara at glifwc.org> wrote:
> 
> Good morning.
> We are running a WAY out of date postgres (9.1) and postgis (1.5). We are trying to figure out how to upgrade to a current version (hoping to get to PosgreSQL 11 with postGIS 2.5).  Is there a way to directly upgrade to postgres11/postgis2.5 without intermediate steps (upgrades)?  
> Thank you in advance for your time!
> Dara
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190813/eac71313/attachment.html>