Contents
- 1 How to connect from ArcMap to PostgreSQL database?
- 2 How to connect to a database in PostgreSQL?
- 3 What should the port number be for PostgreSQL?
- 4 How to find the IP address of a PostgreSQL cluster?
- 5 What is the port number for PostgreSQL on mamabear?
- 6 Can a SP1 ArcGIS connect to a PostGIS database?
- 7 How is a query layer used in ArcGIS?
- 8 How to create a new query layer in SQL?
How to connect from ArcMap to PostgreSQL database?
To connect from ArcMap, configure the database to accept connections, and create a database connection from the Catalog tree in ArcMap or ArcCatalog. Alter the PostgreSQL pg_hba.conf file and make sure the necessary login or group roles have CONNECT privileges in the database.
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 ArcGIS for Desktop. If you have connection files that were created prior to ArcGIS 10.1, they will still work.
Where do I find database connections in ArcGIS?
For all supported databases except SQLite, connect to the database under Database Connections in the Catalog tree. When you do this, a file is created on the client computer that contains the database connection information that you provide.
What should the port number be for PostgreSQL?
If your PostgreSQL database cluster is listening on a port other than the default (5432), include the port number in the instance. For example, if PostgreSQL is installed on server mamabear and is listening on port 49200, type mamabear,49200 in the Data source text box. Choose Database authentication for the Authentication Type.
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. Choose PostgreSQL from the Database Platform drop-down list.
How to find the IP address of a PostgreSQL cluster?
In the Instance text box, type the database cluster name or IP address of the server where PostgreSQL is installed. For example, if your PostgreSQL database cluster is named ficus, type ficus in the Instance text box. If specifying an IPV6 address, enclose the address in brackets.
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.
What is the port number for PostgreSQL on mamabear?
If your PostgreSQL database cluster is listening on a port other than the default (5432), include the port number in the instance. For example, if PostgreSQL is installed on server mamabear and is listening on port 49200, type mamabear,49200 in the Instance text box.
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.
Can a SP1 ArcGIS connect to a PostGIS database?
ArcGIS 10.1 SP1 can connect to PostGIS 2.0.0 databases natively, but the connection is read-only, and mostly functions as a cleaner front end to query layers (in fact, it just loads any layers as query layers).
How to connect PostGIS geometry to ArcGIS geometry?
If you are using ArcGIS 10.0 or later, then you can directly connect to the PostGIS Data using a Query Layer, there is more information on this available in the help of each version: To use the PostGIS geometry type, the database administrator must install PostGIS on the PostgreSQL database cluster.
How is a query layer used in ArcGIS?
The properties of a query layer are used to filter the rows returned to ArcGIS from the database. For example, if you have geometries in a table that have multiple SRIDs, the SRID property set on the query layer will be used to prevent any rows in the database table that don’t match that SRID from being displayed in ArcMap.
How to create a new query layer in SQL?
1 On the New Query Layer dialog box, specify a name in the Name text box for the query layer that will be created. 2 Enter an SQL query into the Query text box. 3 Once the query is created, it must be validated. 4 If your query is successfully validated, click Finish to add the result set to ArcMap as a query layer.