Contents
How do I connect to a PostgreSQL database using ArcGIS?
Connect to the database
- Expand Database Connections in the Catalog tree in ArcMap or ArcCatalog and double-click Add Database Connection.
- Choose PostgreSQL from the Database Platform drop-down list.
- In the Instance text box, type the database cluster name or IP address of the server where PostgreSQL is installed.
How do I add a database connection in ArcGIS?
Start ArcMap, open the Catalog window, and expand the Database Servers folder in the Catalog tree. To connect, do one of the following: Double-click the database server connection icon in the Catalog tree. Right-click the database server connection icon in the Catalog tree and click Connect.
How to connect to PostgreSQL from ArcGIS Pro project?
To connect to a PostgreSQL database from an ArcGIS Pro project, configure the database to accept connections and create a database connection. Alter the PostgreSQL pg_hba.conf file and make sure the necessary login or group roles have CONNECT privileges in the database.
What happens when you connect to a database in ArcGIS Pro?
When you connect to a database in ArcGIS Pro, you’re prompted to fill in the connection properties. These properties help ArcGIS Pro locate the database and provide authentication information to allow you to log in to the database. The information here does not apply to connections to SQLite databases or GeoPackage files.
How to connect to a database in PostgreSQL?
You can connect to a database or geodatabase in PostgreSQL by adding a database connection under the Database Connections node in the Catalog tree in ArcMap or ArcCatalog. Expand Database Connections in the Catalog tree in ArcMap or ArcCatalog and double-click Add Database Connection.
Do you need to download client files to connect to ArcGIS Server?
ArcGIS for Server includes PostgreSQL client files; therefore, you do not need to download and copy PostgreSQL client files to connect. If you want the services you publish to ArcGIS Server to use the data in your database or a geodatabase in PostgreSQL, register the database with ArcGIS Server.