Connect to RDS AWS Postgres Database from ArcMap.

159
2
01-22-2021 01:07 PM
DiegoLlamasOlivares
New Contributor II

Hello,

 

I create a RDS database in AWS using this option.

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

aws2.PNG I've been using this endpoint URL..

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

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

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

 

Thanks,

 

Diego Llamas

Tags (2)
Reply
0 Kudos
2 Replies
MarcoBoeringa
MVP Regular Contributor

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-enterp...

Reply
0 Kudos
VinceAngelo
Esri Esteemed Contributor

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

Reply
0 Kudos