需要 Workflow Manager 许可。
创建数据库
按以下脚本示例在 PostgreSQL 中设置 Workflow Manager (Classic) 工作空间的数据库。
DROP DATABASE wmx;
CREATE DATABASE wmx WITH OWNER = postgres ENCODING = 'UTF8'
TABLESPACE=wmx_sde_dict;
ALTER DATABASE wmx SET search_path="$user", public, sde;
GRANT ALL ON DATABASE wmx TO public;
GRANT ALL ON DATABASE wmx TO postgres;
使用以下脚本示例安装 PostGIS geometry：
\connect wmx CREATE EXTENSION postgis;
在 Workflow Manager (Classic) 数据库中创建方案
使用以下脚本示例，在 Workflow Manager (Classic) 数据库中创建方案：
\connect wmx
--'sde' schema.
CREATE SCHEMA sde AUTHORIZATION sde;
GRANT ALL ON SCHEMA sde TO sde;
GRANT ALL ON SCHEMA sde TO public;
--'wmx' schema.
CREATE SCHEMA wmx authorization wmx;
GRANT USAGE ON SCHEMA wmx to public;
--'pmeditor' schema.
CREATE SCHEMA pmeditor authorization pmeditor;
GRANT USAGE ON SCHEMA pmeditor to public;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA wmx TO role_wmx_wmx_editor;
--'pmviewer' schema.
CREATE SCHEMA pmviewer autorization pmviewer;
GRANT USAGE ON SCHEMA pmviewer to public;
GRANT SELECT ON ALL TABLES IN SCHEMA wmx TO role_wmx_wmx_viewer;
使用以下脚本示例为将使用 PostGIS geometry 存储创建数据的每个用户授予权限：
GRANT SELECT, INSERT, UPDATE, DELETE ON public.geometry_columns to wmx;
GRANT SELECT ON public.spatial_ref_sys to wmx;
有关创建地理数据库的详细信息，请参阅创建企业级地理数据库。
将索引移动到 wmx_sde_dict_index
使用以下脚本示例将索引排序：
select schemaname, tablespace, indexname, tablespace;
from pg_indexes where schemaname = 'sde'
order by schemaname, tablename, indexname, tablespace;
使用以下脚本示例移动索引：
select 'alter text'|| schemaname||'.'||indexname||'set tablespace wmx_sde_dict_index;' as SQLTXT from pg_indexes where schemaname = 'sde'
order by schemaname, tablename, indexname, tablespace;