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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On > Behalf Of donald.kerr > Sent: Wednesday, June 06, 2012 11:01 AM > To: postgis-users@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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
