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
