topic Connect to RDS AWS Postgres Database from ArcMap. in Geodatabase Questions

Connect to RDS AWS Postgres Database from ArcMap.

DiegoLlamasOlivares — Fri, 22 Jan 2021 21:07:42 GMT

Hello,

I create a RDS database in AWS using this option.

, this is a public database and I've been trying to connect to to postgres database.

I've been using this endpoint URL..

i tried also using DB instance name (shar) and database ports

So In ArcMap i use database connection using postgresSQL, instance name i put endpoint URL with default user and password. and I get his error.

So, i do not know how to connect to database and then create an enterprise geodatabase. Any help will be appreciated.

Thanks,

Diego Llamas

Re: Connect to RDS AWS Postgres Database from ArcMap.

MarcoBoeringa — Sat, 23 Jan 2021 19:30:04 GMT

Are you able to connect to this database at all, e.g. by setting up an ODBC connection in Windows and using the connection test option there?

Maybe one of the posts in this other thread is of some use:

https://community.esri.com/t5/arcgis-enterprise-questions/solved-amazon-postgresql-rds-enable-enterprise-geodatabase/td-p/643107

Re: Connect to RDS AWS Postgres Database from ArcMap.

VinceAngelo — Mon, 25 Jan 2021 04:32:06 GMT

I connect to PostgreSQL RDS databases all the time, however, I *NEVER* connect as the postgres login.

I suggest you create a data ownership login and try connecting as that.

You should make sure that you have enabled the postgis extension in the database, and that the database name is all lower-case (which would give a different error).

- V

Re: Connect to RDS AWS Postgres Database from ArcMap.

AndrewThePrivateSectorDrone — Mon, 22 Aug 2022 16:07:54 GMT

@VinceAngelo on a related (albeit late) note: are there any settings that must be updated to get decent performance from a PostGreSQL RDS instance in AWS? The geometry field of spatial datasets seems to absolutely obliterate performance in the PG_Geometry format regardless of how we modify the RDS settings.

Re: Connect to RDS AWS Postgres Database from ArcMap.

VinceAngelo — Mon, 22 Aug 2022 16:33:07 GMT

I'm not sure what you might mean by this. I've never modified any settings. AWS just works.

I should point out that there can be significant performance issues across missions. I had a three network hop solution (with shared router load among a couple of hundred power users) that was an order of magnitude slower than local access. But that's just AWS being AWS -- tightly coupled applications need to be in the same mission.

- V