Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Redump from postgis < 1.0.0

9 views
Skip to first unread message

Henning Bredel

unread,
May 16, 2009, 10:03:01 AM5/16/09
to
Group,

I want to redump a DB which was dumped with a PostGIS
version < 1.0.0 (don't know the exact version, so as
the postgreSQL version).

The restore.sql script looks after a libpostgis.so.08
file, which AFAIK is now liblwgeom.so which defines
the old functions (and types respectively) like

histogram2d_in

as

lwhistogram2d_in

Is there a converting script out there, to correct the
restore.sql (for the newer versions)? Or do you have
other hints/alternatives?

My current version of postgres/postgis is the ubuntu-
bundle from Hardy repository:

postgres-8.3-postgis (postgres: 8.3, postgis: 1.3.3-1)

Thanks for answeres

Henning

--
. . . no signature

Henning Bredel

unread,
May 16, 2009, 2:46:38 PM5/16/09
to
On Sat, 16 May 2009 14:03:01 +0000, Henning Bredel wrote:

> Group,
>
> I want to redump a DB which was dumped with a PostGIS version < 1.0.0
> (don't know the exact version, so as the postgreSQL version).
>

Just found the `postgis_restore.pl' script in the postgis
distribution pack .. didn't come with the package bundle
from the repository.

The script is currently running .. let's see if all works
fine -- until now, it looks great :)

Regards

0 new messages