Difference between revisions of "PostGIS & ArcSDE part 2"

Revision as of 04:09, 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, same pw as postgres user for ease)

\c postgis

create schema authorization sde;

grant usage on schema sde to public;

createuser ufladmin (superuser, etc.)

create schema authorization ufladmin;

grant usage on schema ufladmin to public;

@@ Line 1: / Line 1: @@
-* install from Arc installs
+See instructions (windows/documentation_server/ARCSDE93POSTGRESQLINSTALLGUIDES/install_gd_postgresql.htm)
-* otherwise the postgres service name is fucked up and Arc doesn't see the service name it expects
-* do not install stack builder
+# install PostgreSQL
-* install Postgis
+# install PostGIS
+# Install ArcSDE
+## 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, same pw as postgres user for ease)
+#: \c postgis
+#: create schema authorization sde;
+#: grant usage on schema sde to public;
+#: createuser ufladmin (superuser, etc.)
+#: create schema authorization ufladmin;
+#: grant usage on schema ufladmin to public;