Skip To Content

Geodatabases in PostgreSQL used with ArcGIS on AWS

When you deploy ArcGIS Enterprise or stand-alone ArcGIS Server (Enterprise edition) sites on Amazon Web Services (AWS), you can create and register a geodatabase in Amazon Relational Database Service (RDS) for PostgreSQL, including Amazon Aurora (PostgreSQL-compatible edition) with your federated or stand-alone ArcGIS Server sites.

Geodatabases created in Amazon Relational Database Service (RDS) for PostgreSQL store spatial data using the PostGIS geometry storage type.

Once the geodatabase is created and registered with the site, you need to move data into the geodatabase. When you publish services from this data, the data remains in the geodatabase.

Use ArcGIS tools to create a geodatabase

The ArcGIS Enterprise on Amazon Web Services deployment tools provide options to include a geodatabase in Amazon Relational Database Service (RDS) for PostgreSQL or Amazon Aurora (PostgreSQL-compatible edition). The geodatabase created by these deployment tools is named egdb. ArcGIS Enterprise Cloud Builder Command Line Interface for Amazon Web Services and ArcGIS Enterprise Cloud Builder for Amazon Web Services register the geodatabase as the ArcGIS Server site's managed database. When you use Esri AWS CloudFormation templates, you have the option to add the geodatabase as a registered database or managed database.

The deployment tools create the following users:

  • sde: The sde user owns the geodatabase system objects and is considered the geodatabase administrator. The password for this user is the same as the password you specified for the ArcGIS Server primary site administrator.
  • EsriRDSAdmin: The EsriRDSAdmin user is the RDS master user. The templates use this user to create the database and the sde user. The password for this user is the same as the password you specified for the ArcGIS Server primary site administrator.

Use AWS Management Console

If you create your site using the AWS Management Console and want to use Amazon Relational Database Service (RDS) for PostgreSQL or Amazon Aurora (PostgreSQL-compatible edition) for data storage, you need to create the database, login roles, schemas, and enterprise geodatabase yourself, grant the login roles the privileges they require, and register the geodatabase with your ArcGIS Server site. See Create a geodatabase on Amazon Relational Database Service (RDS) for PostgreSQL or Aurora PostgreSQL for more information.