As an ArcGIS Server administrator or a publisher in your organization, you have the option to register your on-premises data stores and cloud stores. In doing so, you are registering data folders, databases, and geodatabases with ArcGIS Server so that services you publish can reference the data in those folders, databases, and geodatabases. Data registration provides ArcGIS Server a list of locations to access. Data registration also helps ArcGIS Server adjust data paths when publishing across machines.
The following sections describe how you can prepare your ArcGIS client to connect to a PostgreSQL database (whether the database contains a geodatabase or not) and register the database with ArcGIS Server.
The PostgreSQL login or group role you use to connect to the database must be granted privileges in the database to access the data to be published.
- The role must be able to connect to the database. By default, this is granted to the public group. If you revoke that privilege from the public group, you must grant it to specific login roles or groups.
- The role must be granted USAGE privileges on all schemas that contain data or other resources to be published. If you are using a geodatabase, the role must be granted USAGE on the sde schema.
- The role must be granted at least SELECT privileges on data to be published.
- If you will be publishing editable feature services, the role must be granted the required privileges—INSERT, UPDATE, and/or DELETE—on the data to be edited. You can grant SELECT, INSERT, UPDATE, and DELETE privileges from ArcGIS Desktop. See Grant and revoke dataset privileges for more information.
- If you will be registering the geodatabase as a managed database, the user with which you connect must have privileges sufficient to create data in the geodatabase and must own a schema that matches the database user name.
See Privileges for geodatabases in PostgreSQL for more information on privileges for different types of database users.
Connect to PostgreSQL
To register a database with the server, you must provide connection information. There are two ways you can do this:
- Import an existing .sde file that contains the connection information.
You can create a database connection (.sde) file from the Catalog tree in ArcMap, the Project pane in ArcGIS Pro, or using the Create Database Connection geoprocessing tool.
- If you register from ArcGIS Desktop, you can provide your connection information at the time of registration.
No matter which way you choose, you must provide the following information to connect to PostgreSQL:
- The type of DBMS to which you are connecting (in this case, PostgreSQL)
- The name of the server on which PostgreSQL is installed
- Authentication type set to database authentication
- A valid database login name and password, which must be saved with the connection
- The name of the database
For more information, see Database connections in ArcGIS Desktop.
Beginning with ArcGIS 10.3 geodatabases, you cannot use an ArcSDE service to connect. If you want to connect to a previous release geodatabase using an ArcSDE service, create a .sde file using the Create ArcSDE Connection File geoprocessing tool or a Python script. Then you can import the connection when you register the geodatabase with ArcGIS Server.
Register with ArcGIS Server
You can register the database from ArcGIS Server Manager or the Catalog tree in ArcMap. See the following topics for an explanation of registration options and how to register the database: