User Tools

Site Tools


arcsde

Red Hat Enterprise 7 + PostGIS for ArcGIS

rpm -ivh https://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-8.noarch.rpm
rpm -ivh http://yum.postgresql.org/9.3/redhat/rhel-7-x86_64/pgdg-centos93-9.3-1.noarch.rpm
yum install postgresql93 postgresql93-server postgresql93-libs postgis2_93
su postgres
/usr/pgsql-9.3/bin/initdb -D /var/lib/pgsql/9.3/data/ --locale=cs_CZ.UTF8 -E UTF-8
exit

systemctl enable postgresql-9.3
systemctl start postgresql-9.3
mkdir /var/lib/pgsql/9.3/data/sde
chown postgres:postgres /var/lib/pgsql/9.3/data/sde
CREATE ROLE sde LOGIN PASSWORD '{PASSWORD}' superuser noinherit createdb;

CREATE TABLESPACE sde OWNER sde LOCATION '/var/lib/pgsql/9.3/data/sde';

CREATE DATABASE company OWNER sde ENCODING 'UTF8' TABLESPACE sde;
GRANT ALL ON DATABASE company TO sde;

\c company
CREATE EXTENSION postgis;
CREATE EXTENSION postgis_topology;

CREATE SCHEMA sde AUTHORIZATION sde;
GRANT ALL ON SCHEMA sde TO sde;

GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE public.geometry_columns TO sde;
GRANT SELECT ON TABLE public.spatial_ref_sys TO sde;

Install extensions

st_geometry.so -> /usr/pgsql-9.3/lib
libst_raster_pg.so -> /usr/pgsql-9.3/lib
chown +x

Deploy DB Schema in ArcGIS Desktop

Connect to server and select “Enable Geodatabase”

arcsde.txt · Last modified: 2017/07/04 10:36 by Jan Forman