Part 4: ArcSDE on Red Hat Linux

Continue the installation process and install the other required packages. After all the installation has been done you can now execute the sdesetup command as user to setup the SDE database template. The command is written as follows:

• sdesetup -o install -d POSTGRESQL -u user -p password -D databasename -s serveraddress -l ArcSDELicense.ecp

To start the services identified in you services.sde execute the following command as sde user:

• sdemon -o start -i servicename

Part 4: ArcSDE on Red Hat Linux

Continue the installation process and install the other required packages. After all the installation has been done you can now execute the sdesetup command as user to setup the SDE database template. The command is written as follows:

• sdesetup -o install -d POSTGRESQL -u user -p password -D databasename -s serveraddress -l ArcSDELicense.ecp

To start the services identified in you services.sde execute the following command as sde user:

• sdemon -o start -i servicename

PART 3: ArcSDE on Red Hat Linux

This post contains the continuation of the installation of ArcSDE.

Please note to edit the dbinit.sde file according to your setup. You need to set the settings in the file:

• set PGHOSTADDR = hostaddress (ex. 192.168.50.1)
• set SDE_DATABASE = databasename

PART 3: ArcSDE on Red Hat Linux

This post contains the continuation of the installation of ArcSDE.

Please note to edit the dbinit.sde file according to your setup. You need to set the settings in the file:

• set PGHOSTADDR = hostaddress (ex. 192.168.50.1)
• set SDE_DATABASE = databasename

PART 2: ArcSDE on Red Hat Linux

Follow the video for the ArcSDE installation or refer to the installation instructions from the ArcSDE CD.

PART 2: ArcSDE on Red Hat Linux

Follow the video for the ArcSDE installation or refer to the installation instructions from the ArcSDE CD.

PART 1: ArcSDE on Red Hat Linux

The next part of the tutorial will show you how to create the database for ArcSDE. The procedure is quite the same with PostGIS database but here we need to install ArcSDE to run the setup for the SDE database.

PART 1: ArcSDE on Red Hat Linux

The next part of the tutorial will show you how to create the database for ArcSDE. The procedure is quite the same with PostGIS database but here we need to install ArcSDE to run the setup for the SDE database.

PART 4: PostGIS on Red Hat Linux

Next we then edit the postgresql.conf file. Set the listener address = '*'. The next step is to create the PostGIS database, sde role, schema, and grant the permission for the user.

To create the database template for the PostGIS database, execute this following command:

• psql -d databasename -U user -c "CREATE LANGUAGE plpgsql"
• psql -d databasename -U user -f postgis/postgis.sql
• psql -d databasename -U user -f spatial_ref_sys.sql

To verify all is good, run the command bellow in the database ou just created using psql or PgAdminIII:

• SELECT postgis_full_version();

PART 4: PostGIS on Red Hat Linux

Next we then edit the postgresql.conf file. Set the listener address = '*'. The next step is to create the PostGIS database, sde role, schema, and grant the permission for the user.

To create the database template for the PostGIS database, execute this following command:

• psql -d databasename -U user -c "CREATE LANGUAGE plpgsql"
• psql -d databasename -U user -f postgis/postgis.sql
• psql -d databasename -U user -f spatial_ref_sys.sql

To verify all is good, run the command bellow in the database ou just created using psql or PgAdminIII:

• SELECT postgis_full_version();

PART 2: PostGIS on Red Hat Linux

The next video shows the installation of the following packages:

• libxml2-2.7.6
• postgis-1.5.3

To check weather the installation had some issues or have been successfully completed, run this command on root: ldd -d /usr/lib64/pgsql/postgis-1.5.3.so

The next step is to copy the st_geometry.so and libst_raster.so files from the installation folder to /usr/lib64/pgsql/data directory. these files will be used later in creating the PostGIS and the ArcSDE geodatabase.

Now we run the initdb for PostgreSQL to initialize the database server configuration. We do that by executing this command as postgres: /usr/bin/initdb –D /var/lib/pgsql/data

PART 2: PostGIS on Red Hat Linux

The next video shows the installation of the following packages:

• libxml2-2.7.6
• postgis-1.5.3

To check weather the installation had some issues or have been successfully completed, run this command on root: ldd -d /usr/lib64/pgsql/postgis-1.5.3.so

The next step is to copy the st_geometry.so and libst_raster.so files from the installation folder to /usr/lib64/pgsql/data directory. these files will be used later in creating the PostGIS and the ArcSDE geodatabase.

Now we run the initdb for PostgreSQL to initialize the database server configuration. We do that by executing this command as postgres: /usr/bin/initdb –D /var/lib/pgsql/data

PART 1: PostGIS on Red Hat Linux

The next series of post deals with the PostGIS installation. This will be used for Quantum GIS, an Open Source mapping application, to connect to our PostgreSQL database. 

The video will cover the installation of the following packages:

• GCC- C++
• configuration of ld.so.conf
• proj-4.7.1
• geos-3.3.1

PART 1: PostGIS on Red Hat Linux

The next series of post deals with the PostGIS installation. This will be used for Quantum GIS, an Open Source mapping application, to connect to our PostgreSQL database. 

The video will cover the installation of the following packages:

• GCC- C++
• configuration of ld.so.conf
• proj-4.7.1
• geos-3.3.1

PostgreSQL on Red Hat Linux

This is part of the series of Videos that we have documented in PICTU Bukidnon for the installation of PostgreSQL, PostGIS and ArcSDE.

WE WOULD LIKE TO EXTEND OUR HEARTFELT GRATITUDE TO THE MEMBERS OF THE PHILIPPINE ROAD MANAGEMENT FACILITY (PRMF) TEAM.

PostgreSQL on Red Hat Linux

This is part of the series of Videos that we have documented in PICTU Bukidnon for the installation of PostgreSQL, PostGIS and ArcSDE.

WE WOULD LIKE TO EXTEND OUR HEARTFELT GRATITUDE TO THE MEMBERS OF THE PHILIPPINE ROAD MANAGEMENT FACILITY (PRMF) TEAM.