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

[Donald Kerr]

Thanks, Regina.

After uninstalling, I tried a fresh install of PostgreSQL followed by a
fresh install of PostGIS. The difference this time is that I did not use the
existing data structure and started with a new one. The installation went
well and without error.

I uninstalled then repeated the above process with my existing data
structure and got the same error as before. The data structure was created
using the 32 bit version of PostgreSQL/PostGIS:
postgresql-9.1.3-1-windows.exe (Not 9.1.4).

Is there an incompatibility between 64 bit and 32 bit data structures? Any
pointers appreciated.

Many thanks.

Regards,

Donald


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paragon
Corporation
Sent: 07 June 2012 08:36
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install


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
> 


_______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users