[GIS] Using PostgreSQL with ArcGIS

arcgis-desktoparcgis-serveresri-geodatabasepostgresqlwfs

Have mercy … with Stackexcachange I'm not yet so familiar, so this is initially somewhat opaque. I try to do my best to organize this thread as well as possible.
Recently I've started to get WFS and Feature Access working. WFS works for now. For Feature Access I need a database…

This is the "old" thread: WFS & Feature Access -> Database connection / Database support (ArcGIS 10.2) .

To make it more easy to figure out, what's going wrong, I've started from scratch. Until now the status quo is::

  • I've downloaded the file "PostgreSQL_DBMS_for_Windows_922_136133.exe" from the esri Customer Portal. This package include the PostgreSQL 9.2.2 executable installation.
    So…no I have a new installation of PostgreSQL 9.2.2 64Bit without PostGIS and without modifying something except of the pg_hba.conf file to enable remote access (Remote Access is working)
  • I've also downloaded from the esri Customer Portal the PostgreSQL_Client_Libraries for_Windows_922_136131.exe" file, which includes the Client files for database support. I've copied the 64Bit files to the \bin directory of my ArcGIS Sever installation and I've copied the 32bit files to the \bin directory of my ArcGIS Desktop installation, which is running in my personal computer.
  • As mentioned…the only thing, which I've modified for my psotgreSQL Database is the pg_hba.conf file to grant access via remote connections. This is working! I can access the postgreSQL database running on my server via my personal computer using pg Admin. Here is a small overview of the database: pg Admin "postgres" is the only existing database. There I haven't modified anything.

Now I want to add the Database connection to ArcCatalog. So I open ArcCatalog , go to "Add Database Connection" and there I fill in the necessary information.
The first initial problem is: I can't add the connection to the database, because I haven't got the chance to select one database. The only existing database "postgres" (look screenshot of pg Admin; the database exists!) is not selectable via the "Add Database connection" assistant ArcCatalog. It also doesn't work to type the "postgres" manually in the "Database field". There I get the following error: Connections to system databases are not allowed. Please provide a different database for the connection."error

So….the next step would be to grant access to the postgreSQL database, so I can access it via the "Add Database Connection" wizard or, maybe better?, setting up a new database. But here I don't know which settings the database needs.

I think, it would be the best to figure out step by step what I have to do. So it's easier for you and me.
Thanks a lot and I'm looking forward for some feedback :),
Dominik

Best Answer

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.

Related Question