If you use this installation, no specific nondefault settings are needed to use PostgreSQL with ArcGIS. You can download PostgreSQL installations from My Esri. Obtain and install a supported release of PostgreSQL and configure the database cluster. Install and configure PostgreSQLįollow these steps to set up a PostgreSQL database cluster to store a geodatabase on a Linux server: After the geodatabase is created, you can tighten security on your geodatabase by revoking usage on the sde schema from public and granting usage only to those login groups and roles that need access to the geodatabase.įirst, you must install PostgreSQL and configure the database cluster. Since geodatabase login roles likely do not exist yet, this tool grants usage to public. Login roles that will use the geodatabase must be able to access the sde schema. It sets the sde user as the owner of the sde schema and grants usage on the sde schema to the public role.The geodatabase system tables, views, functions, and procedures are stored in the sde schema. It creates an sde schema in the database.The sde user must be a superuser to create the geodatabase. It creates an sde login role in the database cluster and grants it superuser status.Then you can run the Create Enterprise Geodatabase tool or script, and specify the name of your precreated database. If you need to create the database using a different template-for example, if you want to use the postgis template-you must create the database before running this tool. It creates a database using the PostgreSQL default template (template1).The following describes what the Create Enterprise Geodatabase tool does and the settings it uses: To achieve this, specific default settings are used. The Create Enterprise Geodatabase tool makes it easy to set up a geodatabase because it creates the database objects and grants required privileges for you. If you perform the role of both the database administrator and geodatabase administrator and, therefore, know the password for both login roles, you can use the Create Enterprise Geodatabase geoprocessing tool or Python script to create a geodatabase in PostgreSQL. You are the PostgreSQL and geodatabase administrator The PostgreSQL administrator creates the database the geodatabase administrator creates the geodatabase.You are the PostgreSQL and geodatabase administrator.Follow the instructions that apply to your situation: Determine who will create the geodatabase, as that affects who creates the database, and which tool you run to create the geodatabase.Obtain an ArcGIS Server keycodes file and place it in a location you can access from the ArcGIS client you'll use to create the geodatabase.Confirm the ArcGIS, PostgreSQL, and operating system combinations you want to use are compatible.To create a geodatabase in PostgreSQL, do the following: If you have PostgreSQL installed on a Microsoft Windows server, see Create a geodatabase in PostgreSQL on Windows. Note that this topic applies to PostgreSQL installations on a Linux server. Start by reading the prerequisites, then follow the instructions that apply to your situation. To create a geodatabase in a PostgreSQL database, you run a geoprocessing tool or Python script from an ArcGIS client.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |