[postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install

[Paragon Corporation]

Donald,
This is extremely odd.  Seems like its breaking when its trying to compile
the topology addtosearchpath function
 as you are getting compiled function gibberish it seems.

That function is in postgis_topology, so what you could do is just use the
binaries (you might not even need to as the files would have installed
already).


Try installing postgis in a new database with 

CREATE EXTENSION postgis;


I haven't done a fresh install of PostGIS against 9.1.4 so can't be sure if
its an issue in 9.1.4 release or not.

Hope that helps,
Regina
http://www.postgis.us 

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of donald.kerr
> Sent: Wednesday, June 06, 2012 11:01 AM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] PostgreSQL/PostGIS x64 Error on 
> PostGIS Install
> 
> Hi List,
> 
> I am trying to set up a Windows 7 x64 laptop with PostgreSQL 
> and PostGIS. Both program versions are x64 as follows:
> 
> PostgreSQL: postgresql-9.1.4-1-windows-x64.exe
> PostGIS: postgis-pg91x64-setup-2.0.0-4.exe
> 
> I am using an existing data directory and the PostgreSQL goes 
> well, reporting no errors - confirmed running in services. I 
> never used StackBuilder to install PostGIS as my connection 
> at this location is poor.
> 
> When I try to install PostGIS (using the above install file), 
> the following error is reported:
> 
> Database installation of PostGIS functions failed
> 
> Error log:
> -----------------------------------------------------------
> ERROR:  expected "]" to end datum, but got "9212} :resno 1 
> :resname set_config :ressortgroupref 0 :resorigtbl 0 
> :resorigcol 0 :resjunk false}) :returningList <> :groupClause 
> <> :havingQual <> :windowClause <> :distinctClause <> 
> :sortClause <> :limitOffset <> :limitCount <> :rowMarks <> 
> :setOperations <> :constraintDeps <>})"; length = 1
> LINE 1: SELECT reset_val                          FROM 
> pg_settings W...
>                                                        ^
> QUERY:  SELECT reset_val                          FROM 
> pg_settings WHERE name = 'search_path'
> CONTEXT:  PL/pgSQL function "addtosearchpath" line 6 at SQL statement
> -----------------------------------------------------------
> 
> That's as far as it gets.
> 
> Any help would be appreciated.
> 
> Many thanks.  Regards,
> 
> Donald
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>