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

From: Athanasios Kostopoulos <athanasios(dot)kostopoulos(at)classmarkets(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: upgrading from postgresql 8.4 - postgis 1.3.6 to postgresql 9.2/postgis2.0
Date: 2013-09-06 09:38:32
Message-ID: CAFnWstODNTajQZQ-iMSjFKuoKBvRRQ3L7GOTmcGGP8OxotpqMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear list,
first of all thanks for the direct and indirect help all this time. I now
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 their 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 and an unusuable
database at the end.

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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message James David Smith 2013-09-06 09:43:58 Re: Writing results while loop ongoing?
Previous Message Beena Emerson 2013-09-06 09:23:35 Re: Understanding Encoding