Greetings,
I'm trying to create an enterprise geodatabase using ESRI's built in tools. I tried using the GUI in ArcGIS Pro, but received a "Bad User" error message. So I tried recreating the tool using the script below. I removed all the sensitive information FYI.
Our DevOps team created a PostgreSQL db is located on an AWS instance.
Additionally, we didn't want to install a Desktop instance on the servers that serve our Portal. So I'm running this script on my local machine. For the authorization file parameter, we retrieved the 'keycodes' file from the machine serving our enterprise.
Given the code and traceback below, does anyone have any ideas where we are going wrong in our attempt to create an enterprise gdb?
import arcpy
arcpy.management.CreateEnterpriseGeodatabase(
database_platform="PostgreSQL",
instance_name="*",
database_name="*",
account_authentication="DATABASE_AUTH",
database_admin="postgres",
database_admin_password="**",
sde_schema="SDE_SCHEMA",
gdb_admin_name="sde",
gdb_admin_password="**",
tablespace_name='',
authorization_file=r"C:/SDE_Connection/keycodes"
)
Traceback (most recent call last):
File "C:/SDE_Connection/create_sde.py", line 13, in <module>
authorization_file=r"C:\SDE_Connection\keycodes"
File "C:\Program Files (x86)\ArcGIS\Desktop10.8\ArcPy\arcpy\management.py", line 5151, in CreateEnterpriseGeodatabase
raise e
ExecuteError: Server machine not found
Failed to execute (CreateEnterpriseGeodatabase).
