« Adding stable file download links to the Research Bibliography - Part 1 | Main | Google Indexing speed »
March 30, 2011
Installing PostGIS and Postgres on Ubuntu
Note: These are my working notes, there are better tutorials online.
PostgresSQL and PGAdmin
$ sudo apt-get install postgresql postgresql-client postgresql-contrib pgadmin3
PostGIS
$ sudo apt-get install postgresql-8.4-postgis
$ sudo su postgres
$ createdb postgistemplate
$createlang plpgsql postgistemplate
These fail (no file or directory):
psql -d postgistemplate -f /usr/share/postgresql-8.2-postgis/lwpostgis.sql
psql -d postgistemplate -f /usr/share/postgresql-8.2-postgis/spatial_ref_sys.sql
Install PHPpgAdmin (because it is different than pgadmin3):
$ sudo apt-get install phppgadmin
$ sudo nano /etc/apache2/apache2.conf
$ sudo nano /etc/phppgadmin/apache.conf
$ sudo service apache2 reload
Login to postgresql:
$ sudo -u postgres psql postgres
Set superuser password:
postgres=# \password postgres
Restart postgresql:
$ sudo /etc/init.d/postgresql-8.4 restart
To connect via PHPPgAdmin you need to create a non-superuser role (i.e., you can't connect via user postgres)
Posted by kkwaiser at March 30, 2011 03:09 PM
Trackback Pings
TrackBack URL for this entry:
http://mblog.lib.umich.edu/mt-bin/mt-tb.cgi/2166
Listed below are links to weblogs that reference Installing PostGIS and Postgres on Ubuntu:
» christian louboutin uk from christian louboutin uk
Bonjour, je voudrais votre blog. Avez-vous besoin de visiteur publier sur mon propre à un certain moment? Si donc s'il vous pla?t me renseigner par l'intermédiaire d'e-mail ou peut-être répondre à ce genre d'opinion depuis Nous avons inclus dans l... [Read More]
Tracked on April 6, 2013 01:14 AM
» cheap nike blazers from cheap nike blazers
I'll gear this review to 2 types of people: current Zune owners who are considering an upgrade, and people trying to decide between a Zune and an iPod. (There are other players worth considering out there, like the Sony Walkman X, but I hope this gives... [Read More]
Tracked on April 10, 2013 02:57 AM
» rKcHsQWy from rKcHsQWy
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on April 10, 2013 03:09 AM
» burberry bags from burberry bags
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on April 13, 2013 12:33 AM
» office 2013 key from office 2013 key
I think this is wonderful I truly appreciate the informations shared in this post I am going to bookmark this! [Read More]
Tracked on April 14, 2013 12:50 PM
» red bottom shoes from red bottom shoes
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on April 14, 2013 09:35 PM
» celine bags from celine bags
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on April 14, 2013 10:38 PM
» seo tools from seo tools
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on April 14, 2013 11:10 PM
» miu miu from miu miu
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on April 14, 2013 11:44 PM
» hermes bags from hermes bags
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on April 15, 2013 06:52 PM
» wow gold from wow gold
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on April 15, 2013 09:28 PM
» mulberry bags from mulberry bags
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on April 16, 2013 09:52 AM
» sac louis vuitton from sac louis vuitton
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on April 24, 2013 05:55 AM
» www.buyairshoes.com from www.buyairshoes.com
Terminate Air Jordan 11 Concord Size 6 Complaints Totally [Read More]
Tracked on April 25, 2013 12:29 PM
» christian louboutin uk sale from christian louboutin uk sale
Cheap Christian Louboutin Shoes [Read More]
Tracked on May 1, 2013 09:59 AM
» search engines from search engines
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on May 2, 2013 01:07 AM
» christian louboutin glitter pumps from christian louboutin glitter pumps
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on May 4, 2013 02:06 AM
» diablo 3 gold from diablo 3 gold
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on May 5, 2013 02:34 AM
» 整形美容 from 整形美容
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on May 6, 2013 07:14 PM
» Watch Movies from Andro from Watch Movies from Andro
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on May 7, 2013 04:42 PM
» christian louboutin wedding shoes from christian louboutin wedding shoes
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on May 11, 2013 11:06 AM
» Wow Gold from Wow Gold
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on May 13, 2013 01:52 PM
» nike pas cher from nike pas cher
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on May 15, 2013 07:56 AM
» cheap prom dresses from cheap prom dresses
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on May 15, 2013 07:56 AM
» Oakley M Frame Sunglasses from Oakley M Frame Sunglasses
Mainly because of Al Kaline's will to win he refused to ever attend a World Series baseball game until he played in one. Luckily in his 16th season in the Key Leagues, he lastly got his opportunity to play in the Series in 1968. [Read More]
Tracked on May 16, 2013 12:58 AM
» Cheap Jerseys from Cheap Jerseys
Possibly the ideal quote that you could ever acquire from a ball player came from arguable the greatest hitter ever to play the game of baseball. The Splendid Splinter once mentioned about Kaline, "There's a hitter. In my book he's the greatest suitabl... [Read More]
Tracked on May 18, 2013 03:29 PM
» polo outlet online from polo outlet online
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]
Tracked on May 20, 2013 05:21 PM
» replica designer handbags from replica designer handbags
Data Discussions: Installing PostGIS and Postgres on Ubuntu cheap designer bags [Read More]
Tracked on May 21, 2013 06:36 PM