[postgis-users] upgrading from postgresql 8.4 - postgis 1.3.6 to postgresql 9.2/postgis2.0

[Marcos Cano]

I did that a few months ago... Basically what I did was..


Install pg9.2.4 (latest stable version) with disable-integer-datetimes

And postgis 2.0.3 pointing against this Postgres version  with :
 --with-pgconfig= thepath/to/pg9.2.4/bin/pg_config

I run the both servers the newest in a different tcp port because there
were something's I still need from
That server.

Do a pg_dump of the postgis enabled database..  I did the pg_dump with the
/bin/ folder of
The older version.


In the new server I created a spatially enabled database make sure you make
it the long way (without EXTENSIONS)

Then I did a restore with the perl script

Greetings

On Friday, September 6, 2013, Athanasios Kostopoulos wrote:

> Dear list,
> I have a problem that proves to be quite the brain-teaser (at least for
> me).
>
> I have an ancient database (8.4.X) integrated with postGIS 1.3.6. Clearly,
> this while currently working will reach end of life soon and needs to be
> upgraded.
>
> On a Debian wheezy system, I installed postgres 9.2/postgis2.0 - all from
> the apt repositories provided by postgres. When I try to do things the
> recommended way from postGIS (processing the backup with the perl script)
> during restore I get a few errors and constantly increasing memory usage,
> until the restore process will die with an "out of memory error". When I
> try to restore the "pure" dump, I get a number of errors.
>
> Now, I understand that I am talking a big increase in major versions,
> including some non backwards compatible changes in postgis but such an
> upgrade should be feasible. Can someone give me a small push, so I can move
> forward with this? I would prefer to upgrade to the latest versions of
> postgresql and postGIS, if such a thing is possible.
>
> Thanks in advance for any replies.
>
> classmarkets GmbH | Schumannstraße 6 | 10117 Berlin | Deutschland
> Tel: +49 (0)30 56 59 001-0 | Fax: +49 (0)30 56 59 001-99 |
> www.classmarkets.com
>
> Amtsgericht Charlottenburg HRB 111815 B | USt.Id.Nr: DE 260731582
> Geschäftsführer: Veit Mürz, Fabian Ströhle
>
> Diese Nachricht (inklusive aller Anhänge) ist vertraulich. Sie darf
> ausschließlich durch den vorgesehenen Empfänger und Adressaten gelesen,
> kopiert oder genutzt werden. Sollten Sie diese Nachricht versehentlich
> erhalten haben, bitten wir, den Absender (durch Antwort-E-Mail) hiervon
> unverzüglich zu informieren und die Nachricht zu löschen. Jede unerlaubte
> Nutzung oder Weitergabe des Inhalts dieser Nachricht, sei es vollständig
> oder teilweise, ist unzulässig. Bitte beachten Sie, dass E-Mail-Nachrichten
> an den Absender nicht für fristgebundene Mitteilungen geeignet sind.
> Fristgebundene Mitteilungen sind daher ausschließlich per Post oder per
> Telefax zu übersenden.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130906/dec65cb3/attachment.html>