topic Re: ArcSDE 10 - PostGres 8.4.1 and PostGIS 1.4.0 near impossible to find! in Data Management Questions

ArcSDE 10 - PostGres 8.4.1 and PostGIS 1.4.0 near impossible to find!

DrewBlack — Wed, 24 Nov 2010 08:37:10 GMT

Hi,

Just a bit of background, I am trying to install PostGres with PostGIS geometry. In the past I had tested this successfully but it was with ArcSDE 9.3 Postgres 8.3.x and Post GIS 1.3.x. Now I want to get this happening with ArcSDE 10 for testing then move to production.

I have seen the "ArcSDE 10 Postgresql Database Requirements" and it mentions that the supported version of PostGresql is 8.4.1 and the PostGIS version is 1.4.0. How strict are these requirements?

Normally I would follow these to the letter, however I cannot find a version of PostGresql 8.4.1 the best I can find is 8.4.3 and I don't know where it came from (I found it on our network). Also in regards to PostGIS the stack builder suggests 1.4.2 or 1.5.x. I thought maybe I could get away with installing Postgresql 8.4.3 and PostGIS 1.4.2 but unfortunately I come up with some errors in the post install referring to st_geometry.dll missing and another *raster*.dll (can't remember the name). I checked those errors on the forum and all I could come up with is that it is caused by incompatible Postgresql and PostGIS versions grrrr.

So I suppose my questions are
1) Does anyone know where I can get the appropriate versions of Postgres and PostGIS (I have tried the postgres sites, pgfoundary and PostGIS @ Refractions)?
2) Alternatively does has anyone had any success with other versions of PostGresql 8.4 and PostGIS.

Thanks
Clueless83

Re: ArcSDE 10 - PostGres 8.4.1 and PostGIS 1.4.0 near impossible to find!

VinceAngelo — Wed, 24 Nov 2010 13:49:48 GMT

What platform are you using? Source for PostgreSQL 8.4.1 and PostGIS 1.4.0 are
available on their respective web sites; making Linux builds from source isn't much
more than "./configure ; make ; make install".

I'm not adventurous enough to try to make Windows binaries from source. It might
be possible that recent binaries would work, but the support for that is more along
the lines of "If it works, then it's supported; if doesn't then it isn't".

- V

Re: ArcSDE 10 - PostGres 8.4.1 and PostGIS 1.4.0 near impossible to find!

DrewBlack — Wed, 24 Nov 2010 19:38:47 GMT

Thanks Vince, I managed to avoid the windows binaries!

I found the versions of PostGresql and PostGIS. Someone at work had already downloaded the Postgresql version and the PostGIS version I found here at PGFoundary.

I installed the ArcSDE component then went onto the post install and got the errors about st_Geometry.dll and lbst_raster_pg.dll again, even though I have moved then to the appropriate PostGres/lib folder (I also placed them in Postgres/bin just incase). Then a final error saying repository was unsuccessfully completed. However I ran the post install from the start menu, I didn't realise that it had to be done via sql.

So I am now confident in regards to the process of installing for postgresql 8.4.1 but to ensure I am in a position to use PostGIS geometries I have one more quetsion. When it comes to creating a database (step 9 of the install guide under "using Postgresql 8.4.1/creating a gdb in windows") do I skip that step? Or put in the details for the PostGIS db i created with the PostGIS install?

Thanks
Clueless83

Re: ArcSDE 10 - PostGres 8.4.1 and PostGIS 1.4.0 near impossible to find!

VinceAngelo — Wed, 24 Nov 2010 19:55:22 GMT

Are you following the install doc for 8.4.1? I use 8.3.8 and haven't ever tried the
postinstall GUI, so I can't really say.

- V

Re: ArcSDE 10 - PostGres 8.4.1 and PostGIS 1.4.0 near impossible to find!

DrewBlack — Sun, 28 Nov 2010 04:01:25 GMT

Hi Vince,

Yeah I followed the install documentation for 8.4.1. It all went quite well in the end.

Step nine confused me a little bit. In this step you create a database but I had already created a database when I installed PostGIS. So I just skipped this step and manually changed the owner and tablespace in PgAdminlll.

I then changed the default geometry type in DBTUNE and eveything is operating as expected.

Thanks for dropping in every now and the to see how things were going.

Clueless83

Re: ArcSDE 10 - PostGres 8.4.1 and PostGIS 1.4.0 near impossible to find!

weidong — Thu, 03 Feb 2011 06:30:47 GMT

Currently, I am working on this project, and just finish installing the postgresql 8.4.1 and postGIS 1.4.0
on Ubuntu. See as http://www.jeffreydongwei.com/blog/2011/02/03/arcsde-pre-installation-postgresql8-4-1-and-postgis-1-4-0/. Hope this will help.

Re: ArcSDE 10 - PostGres 8.4.1 and PostGIS 1.4.0 near impossible to find!

ToddLaClair — Mon, 21 Feb 2011 18:50:58 GMT

Postgresql 8.4.1 for Windows isn't available for download from Postgresql.org or EnterpriseDB (which maintains the one click installer). Only the most recent minor releases of 8.4.x (8.4.7 is the latest) are available. Does ESRI support 8.4.7 or any version of Postgres more recent than 8.4.1?

Re: ArcSDE 10 - PostGres 8.4.1 and PostGIS 1.4.0 near impossible to find!

tKasiaTuszynska — Wed, 02 Mar 2011 15:14:17 GMT

Hi Cluless,
Sorry to hear that you have having trouble with Postgres and PostGIS versions. Finding back versions of these two apps is a bit of an unresolved issue. On linux platforms where most of the users and developers of these products operate, finding back versions is not much of a problem, but on windows it is the experience you had encountered.
We have had some conversations with the Postgres folks and now the Enterprise DB folks and they maintain that if you fiddle with their folder structure on the website long enough you will find the version of Postgres at least, that you seek. But I have never been successful. This is why we distribute the main version of Postgres that we support. Would you be able to use the provided 8.3.8 version? Unfortunately we are not able to distribute PostGIS so I can not offer you anything on our media, for that application. Have you thought of contacting or commenting on the Refractions Research blogs?
In theory if we certify a major version of Postgres (like 8.4.1) then its minor versions should not have changed anything that would break our st_geometry.dll but in practice that does not always work.
Wishing you the best,
Sincerely,
Kasia

Re: ArcSDE 10 - PostGres 8.4.1 and PostGIS 1.4.0 near impossible to find!

juliaharrell — Fri, 18 Mar 2011 00:19:54 GMT