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 3: PostGIS on Red Hat Linux

The next step is to configure and define some variables in our PostgreSQL server. These variables will be used in creating our database to set the location for our tablespace. We also then need to configure the pg_hba.conf for client authentication. This will enable our clients to access the database. The following video will give us the illustration. 

PART 3: PostGIS on Red Hat Linux

The next step is to configure and define some variables in our PostgreSQL server. These variables will be used in creating our database to set the location for our tablespace. We also then need to configure the pg_hba.conf for client authentication. This will enable our clients to access the database. The following video will give us the illustration. 

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