Introducing ArcSDE Implementation for PostgreSQL…

                      Introducing ArcSDE Implementation for PostgreSQL
                                                         Transcript


Copyright © 2008 ESRI
All rights reserved.
Printed in the United States of America.

The information contained in this document is the exclusive property of ESRI. This work is protected under United States
copyright law and other international copyright treaties and conventions. No part of this work may be reproduced or transmitted
in any form or by any means, electronic or mechanical, including photocopying and recording, or by any information storage or
retrieval system, except as expressly permitted in writing by ESRI. All requests should be sent to Attention: Contracts and Legal
Services Manager, ESRI, 380 New York Street, Redlands, CA 92373-8100 USA.

The information contained in this document is subject to change without notice.

                                U.S. GOVERNMENT RESTRICTED/LIMITED RIGHTS
           Any software, documentation, and/or data delivered hereunder is subject to the terms of the License
           Agreement. In no event shall the U.S. Government acquire greater than RESTRICTED/LIMITED RIGHTS.
           At a minimum, use, duplication, or disclosure by the U.S. Government is subject to restrictions as set forth
           in FAR §52.227-14 Alternates I, II, and III (JUN 1987); FAR §52.227-19 (JUN 1987) and/or FAR
           §12.211/12.212 (Commercial Technical Data/Computer Software); and DFARS §252.227-7015 (NOV
           1995) (Technical Data) and/or DFARS §227.7202 (Computer Software), as applicable.
           Contractor/Manufacturer is ESRI, 380 New York Street, Redlands, CA 92373-8100 USA.

@esri.com, 3D Analyst, ACORN, ADF, AML, ArcAtlas, ArcCAD, ArcCatalog, ArcCOGO, ArcData, ArcDoc, ArcEdit,
ArcEditor, ArcEurope, ArcExplorer, ArcExpress, ArcGIS, ArcGlobe, ArcGrid, ArcIMS, ARC/INFO, ArcInfo, ArcInfo Librarian,
ArcInfo--Professional GIS, ArcInfo--The World's GIS, ArcLessons, ArcLocation, ArcLogistics, ArcMap, ArcNetwork,
ArcNews, ArcObjects, ArcOpen, ArcPad, ArcPlot, ArcPress, ArcQuest, ArcReader, ArcScan, ArcScene, ArcSchool, ArcScripts,
ArcSDE, ArcSdl, ArcSketch, ArcStorm, ArcSurvey, ArcTIN, ArcToolbox, ArcTools, ArcUSA, ArcUser, ArcView, ArcVoyager,
ArcWatch, ArcWeb, ArcWorld, ArcXML, Atlas GIS, AtlasWare, Avenue, Business Analyst Online, BusinessMAP, Community,
CommunityInfo, Data Automation Kit, Database Integrator, DBI Kit, EDN, ESRI, ESRI BIS, ESRI--Team GIS, ESRI--The GIS
Company, ESRI--The GIS People, ESRI--The GIS Software Leader, FormEdit, GeoCollector, Geographic Design System,
Geography Matters, Geography Network, GIS by ESRI, GIS Data ReViewer, GIS Day, GIS for Everyone, GISData Server, JTX,
MapBeans, MapCafé, MapData, MapObjects, Maplex, MapStudio, ModelBuilder, MOLE, MPS-Atlas, NetEngine,
PC ARC/INFO, PC ARCPLOT, PC ARCSHELL, PC DATA CONVERSION, PC STARTER KIT, PC TABLES, PC ARCEDIT,
PC NETWORK, PC OVERLAY, PLTS, Rent-a-Tech, RouteMAP, SDE, Site·Reporter, SML, Sourcebook·America, Spatial
Database Engine, StreetEditor, StreetMap, Tapestry, the ARC/INFO logo, the ArcAtlas logo, the ArcCAD logo, the ArcCAD
WorkBench logo, the ArcCOGO logo, the ArcData logo, the ArcData Online logo, the ArcEdit logo, the ArcEurope logo, the
ArcExplorer logo, the ArcExpress logo, the ArcGIS logo, the ArcGIS Explorer logo, the ArcGrid logo, the ArcIMS logo, the
ArcInfo logo, the ArcLogistics Route logo, the ArcNetwork logo, the ArcPad logo, the ArcPlot logo, the ArcPress for ArcView
logo, the ArcPress logo, the ArcScan logo, the ArcScene logo, the ArcSDE CAD Client logo, the ArcSDE logo, the ArcStorm
logo, the ArcTIN logo, the ArcTools logo, the ArcUSA logo, the ArcView 3D Analyst logo, the ArcView Data Publisher logo,
the ArcView GIS logo, the ArcView Image Analysis logo, the ArcView Internet Map Server logo, the ArcView logo, the
ArcView Network Analyst logo, the ArcView Spatial Analyst logo, the ArcView StreetMap 2000 logo, the ArcView StreetMap
logo, the ArcView Tracking Analyst logo, the ArcWorld logo, the Atlas GIS logo, the Avenue logo, the BusinessMAP logo, the
Community logo, the Data Automation Kit logo, the Digital Chart of the World logo, the ESRI Data logo, the ESRI globe logo,
the ESRI Press logo, the Geography Network logo, the MapCafé logo, the MapObjects Internet Map Server logo, the MapObjects
logo, the MOLE logo, the NetEngine logo, the PC ARC/INFO logo, the Production Line Tool Set logo, the RouteMAP IMS logo,
the RouteMAP logo, the SDE logo, The Geographic Advantage, The World's Leading Desktop GIS, Water Writes,
www.esri.com, www.esribis.com, www.geographynetwork.com, www.gis.com, www.gisday.com, and Your Personal
Geographic Information System are trademarks, registered trademarks, or service marks of ESRI in the United States, the
European Community, or certain other jurisdictions.

Other companies and products mentioned herein may be trademarks or registered trademarks of their respective trademark
owners.
Welcome to the Educational Services Podcast series. My name is Kasia Tuszynska, and I am an ArcSDE
Product Engineer working on the project to implement ArcSDE on PostgreSQL. With the release of
ArcGIS Server 9.3, ArcSDE--a technology of ArcGIS Server that facilitates the storage of spatial data in
relational databases--will increase support for PostgreSQL 8.3.0.


In this podcast, I will address some of the most frequently asked questions related to this project. I will
introduce Postgres, and discuss the supported geodatabase functionality, as well spatial data storage types,
supported platforms, and installation.


PostgreSQL (or Postgres for short) is an open-source database developed and maintained by an open-
source online community. Postgres is a relational database management system that provides a
comparable level of functionality, scalability, and performance to DB2, Informix, SQL Server, or Oracle.
Postgres is released with a Berkeley Software Distribution, or BSD license; therefore, it is free.


The implementation of ArcSDE for Postgres supports full geodatabase functionality. You and your users
will be able to perform any workflow on ArcSDE for Postgres, as you would on any other ArcSDE
implementation. From the perspective of a user, there will be no difference between interacting of data
stored on Postgres, DB2, Informix, SQL Server, or Oracle.


You will be able to use any ArcGIS client application to interact with data stored in Postgres. So, you
could use ArcCatalog to connect to data sources, load and manage data, assign dataset privileges, or
compress your database. In ArcMap, you can create and edit data, create cartographic maps, or MXDs to
be used by an ArcGIS Server map service.


You also have all of the geodatabase functionality at your disposal: creating topologies and geometric
networks, versioning, archiving, replication, and relationship classes, to name a few, or the usage of any
ArcGIS extension. Data residing in Postgres can be used by ArcIMS services or ArcGIS Server services.


To make it easier to make a direct connection to Postgres, the Postgres client libraries are included in
every ArcGIS Client application. Therefore, you will be able to connect to any ArcSDE instance on
Postgres without having to install an additional Postgres component on your client machine.


On the database level, the storage of spatial data has been provided in the form of an ESRI-developed,
user-defined spatial type called ST_Geometry, which follows in the footsteps of ESRI's ST_Geometry



Copyright © 2008 ESRI. All rights reserved.                                                          1
spatial type used in DB2, Informix, and Oracle. The ST_Geometry type comes with OGC-compliant SQL
functions, which you can use to interact with data directly on the database level. It is able to store the data
in Postgres in a compressed (shape) format, natively understood by the geodatabase.


In addition to the ST_Geometry type, ArcSDE for Postgres will also support a spatial type distributed
through the PostGIS application developed by Refractions Research, which is an open-source spatial type.
The currently supported version of PostGIS is 1.3.2. PostGIS comes with its own set of OGC-compliant
SQL functions, which can be used to communicate with the data directly on the database level. ArcSDE
enables data stored in the PostGIS spatial type to participate in most geodatabase functionality, with
limited functionality in the Survey and Cadastral extensions. Through ArcSDE, data stored in the PostGIS
type can be loaded and managed through ArcCatalog, edited in ArcMap, and participate in ArcIMS and
ArcGIS Server services.


Because Postgres is a free database, ESRI will be able to distribute its installation along with the
installation of ArcSDE, as long as Postgres's installation wizards or packages are available for a particular
operating system. Currently, we support ArcSDE for Postgres as a 32-bit application on Windows 2003
Server, Red Hat 4 Linux, as well as Suse 10 Linux. In the future, we also hope to support Spark Solaris
10.


If you are installing on a Windows operating system, you will be able to execute the
ArcSDEPostgreSQL.exe installation wizard provided by ESRI, and it will allow you to install Postgres, as
well as ArcSDE, and complete with the ArcSDE Post Installation setup. So with a single wizard, you can
set up your entire data storage environment. Packaged with a Postgres installation, you will also find a
GUI-management program for Postgres, called pgAdminIII, which is similar to Enterprise Managers for
SQL Server or Oracle.


If you're interested in storing your data on the PostGIS user-defined spatial type, be aware that PostGIS is
not automatically installed; therefore, you will have to enable the Application Stack Builder option on the
PostgreSQL Installation options dialog, when executing the ArcSDEPostgreSQL.exe installation wizard.
It will launch a separate dialog where you can choose to install PostGIS.


If you're installing on a Linux platform, you will be able to execute the create_pgdb.sde shell script to
install Postgres on Red Hat Linux. For Suse, the Postgres installation needs to be compiled from source.
The remainder of the installation process is the same for both Linux flavors. The setup_pgdb.sde shell



Copyright © 2008 ESRI. All rights reserved.                                                            2
script will prepare the Postgres cluster for ArcSDE and the install script will install ArcSDE, followed by
a manual post installation.


If you're interested in storing your data on the PostGIS user-defined spatial type on a Linux platform, the
installation of PostGIS would also need to be compiled from source, which you can download from the
PostGIS parent company, Refractions Research.


This podcast addressed the implementation of ArcSDE on the PostgreSQL database management system,
to be available with the 9.3 release of ArcGIS Server. This will allow you to store data in two spatial
types: ST_Geometry--developed by ESRI, and PostGIS geometry type--developed by Refractions
Research. Both data types come with SQL functions allowing you to interact with the spatial data on the
SQL level. Data from both types can participate in geodatabase functionality, and be used through
ArcGIS clients.


ArcSDE for Postgres can be installed on Windows 2003 Server through a wizard, and Red Hat 4 Linux
and Suse10 Linux through shell scripts.


Thank you for listening. For in-depth information and specific topics related to the implementation of
ArcSDE and Postgres, please refer to the ArcGIS Desktop for Server Help.




Copyright © 2008 ESRI. All rights reserved.                                                        3