Changes between Version 13 and Version 14 of UsersWikiPostGIS20Ubuntu1204

Timestamp:

May 5, 2012, 11:03:16 PM (12 years ago)

Author:

jeffmeyer

Comment:

—

UsersWikiPostGIS20Ubuntu1204

@@ -204 +204 @@
  * Maintenance DB: postgres [default]
  * Username: postgres
- * Password: whatever you set in the prior step
+ * Password: whatever you set in the prior step - note that this is the PostgreSQL password and not the system password
  * Store password: uncheck this (or not, based on your security paranoia level)
  * Colour: whatever suits your fancy
@@ -215 +215 @@
 Spatially enabling a database using extensions is a new feature of PostgreSQL 9.1.
 
-Connect to your database using pgAdmin or psql, and run the following commands. To add postgis with raster support:
-{{{
-postgres=# CREATE EXTENSION postgis;
+Connect to a database using pgAdmin or psql, and run the following commands. For example, if you have created a database called 'GIStest', to add postgis with raster support capability to 'GIStest' do the following:
+{{{
+GIStest=# CREATE EXTENSION postgis;
 CREATE EXTENSION
-postgres=#
+GIStest=#
 }}}
 
 To add topology support, a second extension can be created on the database:
 {{{
-postgres=# CREATE EXTENSION postgis_topology;
+GIStest=# CREATE EXTENSION postgis_topology;
 CREATE EXTENSION
-postgres=#
+GIStest=#
 }}}