topic Re: PostgreSQL client files in ArcGIS Enterprise Questions

PostgreSQL client files

BahramJ — Thu, 02 Oct 2014 22:17:59 GMT

Hello dears, how can i download the PostgreSQL client files for ArcGIS desktop 10.2 for connect arcgis desktop to postgreSQL 9.2?
Many thanks

Re: PostgreSQL client files

ChristianWells — Thu, 02 Oct 2014 23:23:10 GMT

Hi Bahram,

probably the easiest way to get all the client libraries required is to download them from the my.esri.com portal. However, they can also be downloaded directly from PostgreSQL. The only issue of downloading them directly from PostgreSQL is that the libiconv-2.dll (for Win32) is not included in the PG binaries, this instead comes from the PostGIS install. If you would like to download the client libraries from the my.esri.com you can use the following steps to download the libraries.

Log into my.esri.com
Click the My Organizations tab
Click Products from the Organization ribbon
Click Downloads from the Products list

5. Click View Downloads next to your current version of ArcGIS for Desktop

6. Expand the Additional Products tab to download the correct version of the PostgreSQL client

Re: PostgreSQL client files

EricTheise — Thu, 02 Oct 2014 23:45:27 GMT

Hi Christian Wells,

Thanks for the clear answer. Unfortunately, I am doing an evaluation and have no My Organization, so I'm blocked at the second step. Also, I'm concerned by the list above, as I'm running PostgreSQL 9.3 and don't see any libraries in the screenshot list. There's already a PostgreSQL 9.4 Beta 2 release, but 9.3 isn't supported?

Any insights greatly appreciated, thanks, bumpy ride coming from the open source world.

Eric

Re: PostgreSQL client files

AsrujitSengupta — Fri, 03 Oct 2014 04:26:50 GMT

PostgreSQL 9.3 or later is not supported with ArcGIS 10.2.x.

PostgreSQL database requirements for ArcGIS 10.2.x

Also please do note the below mentioned in George's post:

However, they can also be downloaded directly from PostgreSQL. The only issue of downloading them directly from PostgreSQL is that the libiconv-2.dll (for Win32) is not included in the PG binaries, this instead comes from the PostGIS install.

Re: PostgreSQL client files

BahramJ — Fri, 03 Oct 2014 08:04:11 GMT

Hi Christian‌, many thanks for your help. I did it but i haven't these option in my esri page.

Re: PostgreSQL client files

AsrujitSengupta — Fri, 03 Oct 2014 12:40:24 GMT

Yes, it seems that you don't have the required permissions to download setups. You can click on the "Request Permissions" option to request the required permissions. The administrator for your organization will receive that request and act accordingly.

Or you can just ask somebody who already has the permissions to download setups, to download it and provide you with the required files.

Re: PostgreSQL client files

BahramJ — Fri, 03 Oct 2014 14:29:37 GMT

Hi Asrujit, many thanks. I haven't this(The administrator for your organization), can you download these options on this image and then send to me?

Re: PostgreSQL client files

EricTheise — Sat, 04 Oct 2014 19:25:34 GMT

Bahram Jomehzadeh‌, I'd suggest you download the PostgreSQL installer from EnterpriseDB. Although the direct link to 9.2.2 is not shown on their downloads page‌, it's fairly obvious how to tweak the url to get to this older version. I installed it, then ran StackBuilder to install PostGIS 2.0.

Once you've installed it, you want to select, copy, and paste the following files from `C:\Program

Files\PostgreSQL\9.2\bin` to `C:\Program Files\ArcGIS\Desktop10.2\bin`: libeay32.dll, libintl.dll, libpq.dll,

ssleay32.dll, and libiconv-2.dll

Works for me™.

Re: PostgreSQL client files

BahramJ — Sun, 05 Oct 2014 07:36:05 GMT

Thanks Eric

Re: PostgreSQL client files

Luxiaoman — Mon, 12 Jan 2015 13:41:00 GMT

I have encountered the same question,can you help me and send the postgreSQL9.2.2 to me?

Re: PostgreSQL client files

Luxiaoman — Mon, 12 Jan 2015 13:41:52 GMT

very thanks!

Re: PostgreSQL client files

AsrujitSengupta — Mon, 12 Jan 2015 13:46:49 GMT

Did you get the required files?

Re: PostgreSQL client files

Luxiaoman — Mon, 12 Jan 2015 13:49:38 GMT

Re: PostgreSQL client files

Luxiaoman — Mon, 12 Jan 2015 13:50:42 GMT

I haven't ,,,,can you help me ?

Re: PostgreSQL client files

Luxiaoman — Mon, 12 Jan 2015 13:54:25 GMT

I haven't got what i want,can you send it to me ?many thanks

Re: PostgreSQL client files

Oliver_Burdekin — Sat, 09 Jul 2016 08:44:53 GMT

Looking at 10.4 downloads it doesn't seem postgres 9.5 is supported. Is it possible to just copy the files across from a PG 9.5 install?