Differences

This shows you the differences between two versions of the page.

--- dba:postgres:gis [2025/12/29 22:09] – created mlivolsi
+++ dba:postgres:gis [2025/12/30 16:01] (current) – mlivolsi
@@ Line 1: / Line 1: @@
 ====== Adding GIS Support to Postgres ======
+<code>
 create role gis_admin login password 'gis_password';
 GRANT rds_superuser TO gis_admin;
 create database gis;
 grant all privileges on database gis to gis_admin;
+</code>
+psql   -h <//hostname//> --username=gis_admin --password --dbname=<//dbname//>
-psql   -h qgis-prd-17.cyongorao4kh.us-east-1.rds.amazonaws.com --username=gis_admin --password --dbname=gis
+<code>
 CREATE EXTENSION postgis;
 CREATE EXTENSION postgis_raster;
@@ Line 13: / Line 18: @@
 CREATE EXTENSION postgis_topology;
 CREATE EXTENSION address_standardizer_data_us;
+</code>
+=== Verify ===
-Verify
+<code>
 SELECT n.nspname AS "Name",
   pg_catalog.pg_get_userbyid(n.nspowner) AS "Owner"
@@ Line 22: / Line 28: @@
   WHERE n.nspname !~ '^pg_' AND n.nspname <> 'information_schema'
   ORDER BY 1;
+  </code>
-transfer ownership
+=== Transfer ownership ===
+<code>
 ALTER SCHEMA tiger OWNER TO gis_admin;
 ALTER SCHEMA tiger_data OWNER TO gis_admin;
@@ Line 40: / Line 48: @@
     relkind IN ('r','S','v') ORDER BY relkind = 'S')
 s;
+</code>
+=== Testing out the installation ===
+<code>
 SET search_path=public,tiger;
@@ Line 55: / Line 66: @@
 -- Should return 1
 SELECT topology.createtopology('my_new_topo',26986,0.5);
+</code>