Contents
- 1 How to register a PostgreSQL database with ArcGIS Server?
- 2 How to connect to a database in PostgreSQL?
- 3 How to find the IP address of a PostgreSQL cluster?
- 4 Why is my Postgres database not connecting to gistest?
- 5 How to create a spatial database in PostgreSQL?
- 6 Where to install geodatabase client in PostgreSQL?
How to register a PostgreSQL database with ArcGIS Server?
To configure that connection, you need to do the following: Grant privileges. Connect to the database. Register the connection file with your ArcGIS Server site. 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 as follows:
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.
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.
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.
What are the requirements for a PostgreSQL database?
The operating system version and updates must also be supported by the operating system provider. Most ArcGIS applications that can connect to a PostgreSQL database include the required PostgreSQL client libraries. These applications include: ArcGIS Server, ArcGIS Desktop, and ArcReader.
Why is my Postgres database not connecting to gistest?
It looks like your error is telling you not to use the postgres database. Probably because that database is normally reserved for the postgresql admin user, postgres. To get rid of this, create a new database called gistest or whatever you like – the owner can still be postgres – and try connecting to the new db.
How to create a spatial database in PostgreSQL?
Probably because that database is normally reserved for the postgresql admin user, postgres. To get rid of this, create a new database called gistest or whatever you like – the owner can still be postgres – and try connecting to the new db. That’s a pretty good walkthrough for setting up a new spatial database using pgAdmin.
Where to install geodatabase client in PostgreSQL?
These clients are usually installed on machines separate from the PostgreSQL database cluster, but they don’t have to be.
Where do I put the Geodatabase file in ArcGIS?
Now that ArcGIS is installed, you have access to the st_geometry.dll file, which must be placed on the PostgreSQL server. You must place the st_geometry.dll file in the PostgreSQL lib directory before you can create a geodatabase. The st_geometry.dll files are installed with ArcGIS clients.
Do you need privileges to ACCESS PostgreSQL database?
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 as follows: The role must be able to connect to the database. By default, this is granted to the public group.