Difference between revisions of "PostGIS & ArcSDE part 2"

Revision as of 05:20, 23 June 2009

See instructions (windows/documentation_server/ARCSDE93POSTGRESQLINSTALLGUIDES/install_gd_postgresql.htm)

install PostgreSQL
install PostGIS
Install ArcSDE
1. cp sg.dll, pe.dll, st_geopmetry.dll from D:\Program Files\ArcGIS\ArcSDE\pgexe\bin to D:\Program Files\PostgreSQL\8.3\lib
in Postgres:
CREATE DATABASE UFL1 template=postgis_template; createuser sde (superuser, set passwd) \c ufl; create schema authorization sde; grant usage on schema sde to public; grant insert,update,delete on public.geometry_columns to sde; createuser ufladmin (superuser, etc.) create schema authorization ufladmin; grant usage on schema ufladmin to public; update sde_dbtune set config_string = 'PG_GEOMETRY' where parameter_name = 'GEOMETRY_STORAGE' and keyword='DEFAULTS';
Use a connection with ufladmin to add data (avoids using sde and postgres users)
GRANT SELECT on [table_name] TO ufl to give UFL user access to data.

@@ Line 7: / Line 7: @@
 # in Postgres:<tt>
 #: CREATE DATABASE UFL1 template=postgis_template;
-#: createuser sde (superuser, same pw as postgres user for ease)
+#: createuser sde (superuser, set passwd)
 #: \c ufl;
 #: create schema authorization sde;
 #: grant usage on schema sde to public;
+#: grant insert,update,delete on public.geometry_columns to sde;
 #: createuser ufladmin (superuser, etc.)
 #: create schema authorization ufladmin;
 #: grant usage on schema ufladmin to public;
+#: update sde_dbtune set config_string = 'PG_GEOMETRY' where parameter_name = 'GEOMETRY_STORAGE' and keyword='DEFAULTS';
 #: </tt>
+# Use a connection with ufladmin to add data (avoids using sde and postgres users)
+# <tt>GRANT SELECT on [table_name] TO ufl</tt> to give UFL user access to data.