PROBLEM
When creating the metadata tables by starting the Metadata Windows service, an error message is returned stating that the current schema is not the same as the users schema.
PostgreSQL 8.3 follows a search path through a determined list of schemas. The search path is the path the system takes to find an authenticated user’s database objects to which they have access. The first matching schema found is selected as the intended schema. If there is no match, an error is returned, even if matching table names exist in other schemas. Once SDE is installed, the default search path is set to:
Code:
search_path
--------------
"$user",public,sde
Code:
grants_pg [host] [port] [sde database] [sdeUser] [gpt schema] [sde schema]
[gptUser]
Where
[host] is the machine name hosting PostgreSQL
[port] is the port number of PostgreSQL. Default = 5432
[sde database] is the SDE database name. Default = sde
[sdeUser] is the sde user. Default = sde
[gpt schema] is the name for the gpt schema. Default = gpt93
[sde schema] is the name of the sde schema. Default = sde
[gptUser] is the name for the gpt schema owner. Default = gpt93
Sample: grants_pg machineName 5432 sde sde gpt93 sde gpt93
Get help from ArcGIS experts
Download the Esri Support App