Difference between revisions of "PostGIS & ArcSDE part 2"
From phurvitz
Phil Hurvitz (talk | contribs) |
Phil Hurvitz (talk | contribs) |
||
| Line 5: | Line 5: | ||
# Install ArcSDE | # 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 | ## 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: | + | # in Postgres:<tt> |
#: CREATE DATABASE UFL1 template=postgis_template; | #: CREATE DATABASE UFL1 template=postgis_template; | ||
#: createuser sde (superuser, same pw as postgres user for ease) | #: createuser sde (superuser, same pw as postgres user for ease) | ||
| − | #: \c | + | #: \c ufl; |
#: create schema authorization sde; | #: create schema authorization sde; | ||
#: grant usage on schema sde to public; | #: grant usage on schema sde to public; | ||
| Line 14: | Line 14: | ||
#: create schema authorization ufladmin; | #: create schema authorization ufladmin; | ||
#: grant usage on schema ufladmin to public; | #: grant usage on schema ufladmin to public; | ||
| + | #: </tt> | ||
Revision as of 05:02, 23 June 2009
See instructions (windows/documentation_server/ARCSDE93POSTGRESQLINSTALLGUIDES/install_gd_postgresql.htm)
- install PostgreSQL
- 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 ufl;
- 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;
