Select to view content in your preferred language

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

1726
8
11-24-2010 12:37 AM
DrewBlack
Emerging Contributor
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
0 Kudos
8 Replies
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
DrewBlack
Emerging Contributor
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
0 Kudos
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
DrewBlack
Emerging Contributor
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
0 Kudos
weidong
New Contributor
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-.... Hope this will help.
0 Kudos
ToddLaClair
Deactivated User
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?
0 Kudos
tKasiaTuszynska
Regular Contributor
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
0 Kudos
juliaharrell
Occasional Contributor
There were no visible links to these 1-click installers from EnterpriseDB anywhere that I could find either. Used a little url hacking & changing version numbers, hoping the files might still there but not exposed, and they were.


could not find anything earlier than 8.3.5 from EnterpriseDB

http://get.enterprisedb.com/postgresql/postgresql-8.3.5-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.3.5-2-windows.exe
(see http://forums.enterprisedb.com/posts/list/1516.page about 8.3.5-2 )
http://get.enterprisedb.com/postgresql/postgresql-8.3.6-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.3.7-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.3.8-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.3.9-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.3.10-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.3.11-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.3.12-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.3.13-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.3.14-1-windows.exe

http://get.enterprisedb.com/postgresql/postgresql-8.4.0-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.4.1-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.4.2-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.4.3-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.4.4-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.4.5-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.4.6-1-windows.exe
http://get.enterprisedb.com/postgresql/postgresql-8.4.7-1-windows.exe

These are the "binaries for advanced users", not the 1-click installers installers.
There did not seem to be any for the 8.3x version...

http://get.enterprisedb.com/postgresql/postgresql-8.4.0-1-windows-binaries.zip
http://get.enterprisedb.com/postgresql/postgresql-8.4.1-1-windows-binaries.zip
http://get.enterprisedb.com/postgresql/postgresql-8.4.2-1-windows-binaries.zip
http://get.enterprisedb.com/postgresql/postgresql-8.4.3-1-windows-binaries.zip
http://get.enterprisedb.com/postgresql/postgresql-8.4.4-1-windows-binaries.zip
http://get.enterprisedb.com/postgresql/postgresql-8.4.5-1-windows-binaries.zip
http://get.enterprisedb.com/postgresql/postgresql-8.4.6-1-windows-binaries.zip
http://get.enterprisedb.com/postgresql/postgresql-8.4.7-1-windows-binaries.zip

I have not tried using just the binaries, but this how-to from Regina Obe might be useful to someone:  http://www.postgresonline.com/journal/archives/172-Starting-PostgreSQL-in-windows-without-install.ht...

There is also an archive of many older versions of PostgreSQL (various combinsations of source, binary, and installers) here:  http://olex.openlogic.com/packages/postgresql#  Although for the 8.x series, there's nothing for windows.


As for PostGIS, this is all I could find. If anyone has a copy of 1.3.7 for windows to share, please post a link...

http://postgis.refractions.net/download/windows/pg83/

http://postgis.refractions.net/download/windows/pg84/

http://postgis.refractions.net/download/windows/pg90/
0 Kudos