Difference between revisions of "PostGIS"

From ArchWiki
Jump to: navigation, search
m
(Creating a Template PostGIS Database)
(12 intermediate revisions by 9 users not shown)
Line 1: Line 1:
[[Category:HOWTOs (English)]]
+
[[Category:Database management systems]]
 
+
PostGIS adds support for geographic objects in the PostgreSQL database. This document describes the process for installing PostGIS and creating a template PostGIS database. It is assumed that PostgreSQL has been installed. If it hasn't, please refer to the [[PostgreSQL]] page.
This document describes the process for installing PostGIS and creating a template PostGIS database. It is assumed that PostgreSQL has been installed. If it hasn't, please refer to the [http://wiki.archlinux.org/index.php/PostgreSQL PostgreSQL] page.
+
  
 
== Installing PostGIS ==
 
== Installing PostGIS ==
 
*Install PostGIS.
 
*Install PostGIS.
 
  $ su
 
  $ su
  $ pacman -Sy postgis
+
  # pacman -S postgis
  
 
== Creating a Template PostGIS Database ==
 
== Creating a Template PostGIS Database ==
 
*Become the postgres user.
 
*Become the postgres user.
 
  $ su
 
  $ su
  $ su - postgres
+
  # su - postgres
 
*If you haven't created a superuser for accessing PostgreSQL, you may want do that now. You will be prompted for granting permissions to that user.
 
*If you haven't created a superuser for accessing PostgreSQL, you may want do that now. You will be prompted for granting permissions to that user.
 
  $ createuser [username]
 
  $ createuser [username]
*Create a new database called "template_postgis" ("-E UTF-8" optional).
+
*Create a new database called "template_postgis".
 
  $ createdb -O [username] template_postgis -E UTF-8
 
  $ createdb -O [username] template_postgis -E UTF-8
 
*PostGIS requires the pl/pgSQL language to be installed on a database.
 
*PostGIS requires the pl/pgSQL language to be installed on a database.
 
  $ createlang plpgsql template_postgis
 
  $ createlang plpgsql template_postgis
*Load the PostGIS spatial types for PostgreSQL and spatial reference systems. "lwpostgis.sql" and "spatial_ref_sys.sql" are part of the installation of PostGIS, and may reside somewhere else besides "/usr/share" depending on the installation.
+
*Load the PostGIS spatial types for PostgreSQL and spatial reference systems. "postgis.sql" and "spatial_ref_sys.sql" are part of the installation of PostGIS, and may reside somewhere else besides "/usr/sharepostgresql/contrib/postgis-1.5/" depending on the installation. ''(Below is for default postgis 1.5 installation)''
  $ psql -d template_postgis -f /usr/share/lwpostgis.sql
+
  $ psql -d template_postgis -f /usr/share/postgresql/contrib/postgis-2.0/postgis.sql
  $ psql -d template_postgis -f /usr/share/spatial_ref_sys.sql
+
  $ psql -d template_postgis -f /usr/share/postgresql/contrib/postgis-2.0/spatial_ref_sys.sql
 +
*Make it a real template.
 +
$ psql
 +
 +
UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template_postgis';
  
 
== Creating a PostGIS Database From the Template==
 
== Creating a PostGIS Database From the Template==
Line 26: Line 29:
 
  $ createdb -T template_postgis [new_postgis_db]
 
  $ createdb -T template_postgis [new_postgis_db]
  
 +
== More Resources ==
 
For additional resources concerning PostGIS, check out the [http://postgis.refractions.net/documentation/ PostGIS Documentation].
 
For additional resources concerning PostGIS, check out the [http://postgis.refractions.net/documentation/ PostGIS Documentation].

Revision as of 06:16, 14 June 2013

PostGIS adds support for geographic objects in the PostgreSQL database. This document describes the process for installing PostGIS and creating a template PostGIS database. It is assumed that PostgreSQL has been installed. If it hasn't, please refer to the PostgreSQL page.

Installing PostGIS

  • Install PostGIS.
$ su
# pacman -S postgis

Creating a Template PostGIS Database

  • Become the postgres user.
$ su
# su - postgres
  • If you haven't created a superuser for accessing PostgreSQL, you may want do that now. You will be prompted for granting permissions to that user.
$ createuser [username]
  • Create a new database called "template_postgis".
$ createdb -O [username] template_postgis -E UTF-8
  • PostGIS requires the pl/pgSQL language to be installed on a database.
$ createlang plpgsql template_postgis
  • Load the PostGIS spatial types for PostgreSQL and spatial reference systems. "postgis.sql" and "spatial_ref_sys.sql" are part of the installation of PostGIS, and may reside somewhere else besides "/usr/sharepostgresql/contrib/postgis-1.5/" depending on the installation. (Below is for default postgis 1.5 installation)
$ psql -d template_postgis -f /usr/share/postgresql/contrib/postgis-2.0/postgis.sql
$ psql -d template_postgis -f /usr/share/postgresql/contrib/postgis-2.0/spatial_ref_sys.sql
  • Make it a real template.
$ psql

UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template_postgis';

Creating a PostGIS Database From the Template

  • It's common practice to reserve a bare template for creating new PostGIS databases. As a PostgreSQL superuser, the following command will create a new database:
$ createdb -T template_postgis [new_postgis_db]

More Resources

For additional resources concerning PostGIS, check out the PostGIS Documentation.