Thread: PgInstallerfor 8.1 beta 3 missing Postgis?

I don't know whether I should be posting to Hacker Win 32 or General,
but I wanted to ask if anyone else has experienced troubles restoring a
DB on windows to 8.1 from 8.0.x when the DB contains GIS tables.

As far as I can see I don't have the postgis dll files or sql script,
but other parts of Postgis are included. I checked the option to install
Postgis in Template1, but find I am unable to either restore any spatial
tables, nor am I able to load sql scripts created with shp2pgsql. I get
the message that geomfromtext is not installed. The contrib diretory has
  a postgis folder, but it only contains some perl scripts, the
postgis.sql file is nowhere to be found.

Is there an updated version of the installer with the missing bits of
postgis?
Cheers
Johan Wehtje

> I don't know whether I should be posting to Hacker Win 32 or
> General, but I wanted to ask if anyone else has experienced
> troubles restoring a DB on windows to 8.1 from 8.0.x when the
> DB contains GIS tables.

That really should go on the pginstaller list. Copying there.


> As far as I can see I don't have the postgis dll files or sql
> script, but other parts of Postgis are included.

That sounds really strange. What parts are those that go in, actually?
;-)
Specifically, which of the following do you get:
libgeos.dll, libproj.dll, pgsql2shp.exe, shp2pgsql.exe, liblwgeom.dll,
lwpostgis.sql, spatial_ref_sys.sql, create_undef.pl, postgis_restore.pl,
postgis_proc_update.sql, rebuild_bbox_caches.pl

(or not get)


> I checked
> the option to install Postgis in Template1, but find I am
> unable to either restore any spatial tables, nor am I able to
> load sql scripts created with shp2pgsql. I get the message
> that geomfromtext is not installed. The contrib diretory has
>   a postgis folder, but it only contains some perl scripts,
> the postgis.sql file is nowhere to be found.

In the current version, that file is now called lwpostgis.sql.

What exactly is the erorr msg?

//Magnus

Magnus,
I have replied to general as well as the only mailing list I could find
on PG Foundry for pginstaller was the Devel list.

I actually do have all those files - the trouble is that the name
changes make pg_restore fail on a dump from a 8.0.3 Database with
spatial (postgis) tables.

Possibly the Perl scripts would take care of this? should I be
installing Perl ?
I created a DB using template1 - but it seems that the function names
have also changed so this error produced during restore --
"
function public.geomfromtext(geometry, integer) does not exist
"
is probably caused by the fact that no such function does exist , but
seems to have been replaced by "geomcollfromtext"

What I cannot understand is why if I try and restore from 8.0.3 into a
Db based on Template0 it should be restoring my original functions?
Though these would not work I suppose as they are expecting the postgis
dll files to be in the libdir, not in the bin dir.

At this stage it is looking more and more like this is a problem with
Postgis, and perhaps i should direct my inquiry there. I did look
through their mailing lists but could not find any information about
dump restore woes such as I am having.

Any suggestions you have would be appreciated

Tack på förhand
Johan Wehtje



Magnus Hagander wrote:
>> I don't know whether I should be posting to Hacker Win 32 or
>> General, but I wanted to ask if anyone else has experienced
>> troubles restoring a DB on windows to 8.1 from 8.0.x when the
>> DB contains GIS tables.
>
> That really should go on the pginstaller list. Copying there.
>
>
>> As far as I can see I don't have the postgis dll files or sql
>> script, but other parts of Postgis are included.
>
> That sounds really strange. What parts are those that go in, actually?
> ;-)
> Specifically, which of the following do you get:
> libgeos.dll, libproj.dll, pgsql2shp.exe, shp2pgsql.exe, liblwgeom.dll,
> lwpostgis.sql, spatial_ref_sys.sql, create_undef.pl, postgis_restore.pl,
> postgis_proc_update.sql, rebuild_bbox_caches.pl
>
> (or not get)
>
>
>> I checked
>> the option to install Postgis in Template1, but find I am
>> unable to either restore any spatial tables, nor am I able to
>> load sql scripts created with shp2pgsql. I get the message
>> that geomfromtext is not installed. The contrib diretory has
>>   a postgis folder, but it only contains some perl scripts,
>> the postgis.sql file is nowhere to be found.
>
> In the current version, that file is now called lwpostgis.sql.
>
> What exactly is the erorr msg?
>
> //Magnus
>
> .
>

> Magnus,
> I have replied to general as well as the only mailing list I
> could find on PG Foundry for pginstaller was the Devel list.
>
> I actually do have all those files - the trouble is that the
> name changes make pg_restore fail on a dump from a 8.0.3
> Database with spatial (postgis) tables.
>
> Possibly the Perl scripts would take care of this? should I
> be installing Perl ?

Okay. Then you really have the whole thing instlaled, and I think the
installer did its job right. I don't know about the postgis upgrade
stuff in particular, you'd better check that with the postgis people
(www.postgis.org). It sounds like it should do it, but I can't tell you
for sure.


//Magnus

Magnus,
Well I checked out with the PostGIS people and their advice was that if
you are restoring Postgis Databases you need Perl installed so that the
restore.pl script can be run. This affects any upgrade from 0.9 or lower
versions of PostGIS to 1.0 or higher.

Given the other changes between 8.0 and 8.1 in Postgres it is probably
worthwhile having a README that opens as soon as the installer is done
with information on upgrading from previous installations as well as
pointers to the change log.

Cheers
Johan Wehtje

Magnus Hagander wrote:
>> Magnus,
>> I have replied to general as well as the only mailing list I
>> could find on PG Foundry for pginstaller was the Devel list.
>>
>> I actually do have all those files - the trouble is that the
>> name changes make pg_restore fail on a dump from a 8.0.3
>> Database with spatial (postgis) tables.
>>
>> Possibly the Perl scripts would take care of this? should I
>> be installing Perl ?
>
> Okay. Then you really have the whole thing instlaled, and I think the
> installer did its job right. I don't know about the postgis upgrade
> stuff in particular, you'd better check that with the postgis people
> (www.postgis.org). It sounds like it should do it, but I can't tell you
> for sure.
>
>
> //Magnus
>
> .
>