Re: [postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install
Ok, Mark, thanks for the confirmation. I suppose then that I would have to dump the contents of the 32 bit setup then import to the 64 bit setup which I'm assuming is possible. Offhand, do you, or does anyone else, know if replication from 32 bit to 64 bit works? What I'm trying to do is maintain one master data structure on a server (currently 32 bit) and replicate to various clients; most are 32 bit but I've just started experimenting with 64 bit clients. I haven't looked at 32 bit to 32 bit replication, never mind complicating matters with 64 bit, as yet but it's on the To Do list. Many thanks. Regards, Donald -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Mark Cave-Ayland Sent: 08 June 2012 14:19 To: PostGIS Users Discussion Subject: Re: [postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install On 07/06/12 14:00, Donald Kerr wrote: > 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. Ah yes. Due to the different variable sizes between 64 and 32 bits, the underlying binary structures on disk will be different and therefore incompatible. HTH, Mark. ___ 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
Re: [postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install
On 07/06/12 14:00, Donald Kerr wrote: 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. Ah yes. Due to the different variable sizes between 64 and 32 bits, the underlying binary structures on disk will be different and therefore incompatible. HTH, Mark. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostgreSQL/PostGIS x64 Error on PostGIS Install
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
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] 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
