topic Re: PostgreSQL support in ArcSDE 10 in Data Management Questions

PostgreSQL support in ArcSDE 10

Kevin_FernandoEscalera_Robles — Tue, 23 Aug 2011 19:04:48 GMT

Will Postgre SQL 9 be supported in ArcSDE 10.1?. I have reviewed the ArcSDE 10 PostgreSQL Database Requirements in http://resources.arcgis.com/content/arcsde/10.0/postgresql-system-requirements and it mentions specific versions of Postgre SQL (8.3.8 and 8.4.1) but I want to be sure that the version 9 is not supported in SDE 10 and will not be supported in ArcSDE 10.1

Thanks in advance

Re: PostgreSQL support in ArcSDE 10

VinceAngelo — Tue, 23 Aug 2011 23:57:52 GMT

PG 9 is not supported at ArcGIS 10.0. 10.1 questions really belong in the beta forums,
but I believe the intent is to support PG 9 at ArcGIS 10.1.

- V

Re: PostgreSQL support in ArcSDE 10

JonDeRose — Mon, 29 Aug 2011 11:41:55 GMT

Hi Kevin,

Please see the following from the 2011 UC:

http://events.esri.com/uc/QandA/index.cfm?fuseaction=answer&conferenceId=DD02CFE7-1422-2418-7F271831F47A7A31&questionId=3945

Q: Will Esri support PostgreSQL 9 at 10.1?

Yes, PostgreSQL 9.0.2 will be supported at 10.1.

Re: PostgreSQL support in ArcSDE 10

Kevin_FernandoEscalera_Robles — Thu, 01 Sep 2011 03:37:36 GMT

Hi Kevin,

Please see the following from the 2011 UC:

http://events.esri.com/uc/QandA/index.cfm?fuseaction=answer&conferenceId=DD02CFE7-1422-2418-7F271831F47A7A31&questionId=3945

Thats all I needed to know, thanks so much

Re: PostgreSQL support in ArcSDE 10

DannyDong — Thu, 13 Oct 2011 16:45:23 GMT

Is there an official date of ArcSDE 10.1 yet? What is the latest version of Postgresql and PostGIS that SDE 10.0 Supports at the time being? There is no installer for Postgresql 8.4.1 as mentioned in ESRI document. So I used postgresql 8.4.9 installer instead. However, I got a database connection error when I tried to post install SDE 10.0. Is there way to get around? Anyone succeeded with a different version than ESRI specifies for Postgresql or PostGIS?

Re: PostgreSQL support in ArcSDE 10

DannyDong — Thu, 13 Oct 2011 19:31:11 GMT

OK. Here is the deal: ArcSDE will not support multiple types of databases on a server, even though it can support multiple databases of the SAME TYPE. I already have SDE databases on a sqlexpress on the same server, that is why I couldn't connect since there can be only ONE SDEHOME.

I know that it is not recommended to have two different types of databases on the same server for performance issues, but I wonder if it is possible now as the server/virtual server/cloud server is getting much more powerful.

Still interested in though what is the update status of postgresql and postgis for sde 10 sp3.

Re: PostgreSQL support in ArcSDE 10

tKasiaTuszynska — Fri, 14 Oct 2011 17:01:23 GMT

Danny,
Couple of answers for you:
You can have multiple sde installations for different databases but yes, you can have only one SDEHOME at a time.

The version of PostgreSQL supported for 10sp3 is the same one as it was for 10.0, 8.3.8 with Postgis 1.5.3.

If you are using a Postgres version that we do not certify, than you run the risk of the Postgres client libraries being different enough from the ones found in the version that we do certify on, for our st_geometry dll/so to be inaccessible. In which case there is nothing that can be done. The only way to fix it would be for the st_geometry library to be recompiled with the newer Postgres client libraries and that ends up being a new release.

Sincerely,
Kasia

Re: PostgreSQL support in ArcSDE 10

DanielMrvos — Fri, 24 Feb 2012 11:40:26 GMT

If you are using a Postgres version that we do not certify, than you run the risk of the Postgres client libraries being different enough from the ones found in the version that we do certify on, for our st_geometry dll/so to be inaccessible. In which case there is nothing that can be done. The only way to fix it would be for the st_geometry library to be recompiled with the newer Postgres client libraries and that ends up being a new release.

Sincerely,
Kasia

Heya,

is there a way for as normal mortal users to get to the source code of the st_geometry library so that we can recompile it for the used Postgres database?

The question why I ask is to test it with Postgres 9, and to circumvent having to do pachtworking like I did with SDE 9.3.1 and Postgres 64bit. Back then I copied the library files from SDE 10 64bit to postgres. Fortunatly it worked back then. But if we have to move to Postgres 9 without moving to GIS 10.1 then we are going to have a problem again in which I again will have to do this patchworking. It would be much easier if we would have the sources of the librarires to compile against the used Postgres version.

Regards,
Daniel

Re: PostgreSQL support in ArcSDE 10

VinceAngelo — Fri, 24 Feb 2012 14:38:14 GMT

There's zero chance of being given the ST_GEOMETRY source. Your best chance
at getting alternate libraries is to file an incident with Tech Support, making a
business case for supporting an unsupported environment (I expect it would have
to be a very compelling argument, just to make it to technical evaluation).

- V

Re: PostgreSQL support in ArcSDE 10

SKIPPYJOHN_JONES — Thu, 16 Aug 2012 13:13:57 GMT

I learnt that ArcGIS 10.1 SUPPORTS UP UNTIL POSTGRESQL 9.0.5.1.
I could only find postgresql instalation package until 9.0.8.1 from postgresqldb website. Does using 9.0.8.1 version creates any problems with arcgis 10.1? Has any one tried it before.

Re: PostgreSQL support in ArcSDE 10

VinceAngelo — Thu, 16 Aug 2012 13:58:11 GMT

The ArcGIS 10.1 media includes the supported PostgreSQL installers. I prefer to
download the source tree from the archive and compile that (trivial on Linux).

- V

Re: PostgreSQL support in ArcSDE 10

SKIPPYJOHN_JONES — Thu, 16 Aug 2012 14:25:41 GMT

The ArcGIS 10.1 media includes the supported PostgreSQL installers. I prefer to
download the source tree from the archive and compile that (trivial on Linux).

- V

Thank you. I want to install post gis on top of postgres and then install ArcSDE to work with PostGIS geometry types. Do you know if ESRI going to support postgis raster types?