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();