Changes between Initial Version and Version 1 of UsersWikiPostGIS21UbuntuPGSQL93Apt

Timestamp:

Dec 9, 2013, 2:56:53 PM (10 years ago)

Author:

mapbaker

Comment:

—

UsersWikiPostGIS21UbuntuPGSQL93Apt

@@ +1 @@
+The [http://wiki.postgresql.org/wiki/Apt PostgreSQL Apt Repository] now hosts installs of PostGIS, in addition to Postgresql and PGAdmin3.
+
+The following describes how to install Postgresql 9.3, PostGIS 2.1, PGAdmin 1.18.1 and shp2pgsql-gui on Ubuntu versions 12.04 through 13.10. 
+
+== Add Respository to sources.list ==
+
+Run in terminal:
+
+{{{sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main" >> /etc/apt/sources.list'}}}
+
+{{{wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -}}}
+
+{{{sudo apt-get update}}}
+
+== Install == 
+The following will install postgresql 9.3, PostGIS, PGAdmin3, and additional supplied modules including {{{adminpack}}}
+
+{{{sudo apt-get install postgresql-9.3-postgis pgadmin3 postgresql-contrib}}}
+
+== Enable Adminpack ==
+
+While in terminal, log in to psql as postgres user:
+
+{{{sudo -u postgres psql}}}
+
+{{{CREATE EXTENSION adminpack;}}}
+
+Quit psql:
+
+{{{\q}}}
+
+== Create new PGSQL user ==
+
+You can create a new database super user to use instead of the default {{{postgres}}} user.
+
+While in terminal, run:
+
+{{{sudo su - postgres}}}
+
+{{{createuser -d -E -i -l -P -r -s yourUserName}}} (be sure to change the username to your desired username)
+
+Enter your new password when prompted
+
+Log out as {{{postgres}}} user:
+
+{{{exit}}}
+
+Exit terminal:
+
+{{{exit}}}
+
+== Use PGAdmin to log into database server ==
+
+From the Ubuntu launcher, type in PGAdmin to reveal the application
+
+Fill in the necessary credentials to log in:
+
+{{{
+- Name: nickname you want to give your connection
+- host: localhost (until you change the connection settings)
+- port: 5432 by default
+- maintenance DB: postgres by default
+- username: whatever you chose in the step above
+- password: whatever you chose in the step above
+}}}
+
+== Enable postgis extensions on new database ==
+
+Since you installed PostgreSQL and PostGIS from the PostgreSQL apt repository, you now have all the extensions for PostgreSQL, including PostGIS
+
+Expand the database tree in PGAdmin, and reveal the extensions node
+
+Right-click the extensions node, and click {{{new extension}}}
+
+Enable the {{{postgis}}} extension, as well as {{{postgis_topology}}}
+
+== Test shp2pgsql-gui ==
+
+Another handy piece of software to use is the {{{shp2pgsql-gui}}} tool. This will allow you to quickly connect to your new PostGIS database and import a Shapefile.
+
+Open terminal, and type:
+
+{{{shp2pgsql-gui}}}
+
+Follow the on-screen prompts to load your data.
+
+For more information, visit the [http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 Boston GIS] tutorial in the section "Load Towns Data"
+
+