Mike's Wiki

User Tools

Site Tools

Trace:
dba:postgres:gis

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
dba:postgres:gis [2025/12/30 14:17] – mlivolsidba:postgres:gis [2025/12/30 16:01] (current) – mlivolsi
Line 1: Line 1:
 ====== Adding GIS Support to Postgres ====== ====== Adding GIS Support to Postgres ======
  
 +<code>
 create role gis_admin login password 'gis_password'; create role gis_admin login password 'gis_password';
  
Line 6: Line 7:
 create database gis; create database gis;
 grant all privileges on database gis to gis_admin; grant all privileges on database gis to gis_admin;
 +</code>
  
 psql   -h <//hostname//> --username=gis_admin --password --dbname=<//dbname//> psql   -h <//hostname//> --username=gis_admin --password --dbname=<//dbname//>
Line 28: Line 30:
   </code>   </code>
  
-=== transfer ownership ===+=== Transfer ownership ===
  
 <code> <code>
dba/postgres/gis.1767104223.txt.gz · Last modified: by mlivolsi