Search Postgresql Archives

Re: PgInstallerfor 8.1 beta 3 missing Postgis?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

.


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux