« 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:

» divorce lawyers working in joliet from divorce lawyers working in joliet
What do I need from a client in order to install Joomla and update their preexisting site? [Read More]

Tracked on February 6, 2014 04:31 PM

» compensation claims broken wrist from compensation claims broken wrist
There are thousands of blogs that requires comments on them. What is the intention of blog comments? [Read More]

Tracked on February 7, 2014 11:25 AM

» Miquel from Miquel
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 7, 2014 11:32 AM

» bayer yasmin pulmonary embolism lawsuit settlements from bayer yasmin pulmonary embolism lawsuit settlements
Hello everyone,. . I am looking to buy a new computer to run an Adobe CS4 Suite. Let just say the Master Suite. I'm mostly going to be running Premiere, Illustrator and Photoshop. I want a computer that is going to completely dominate without any probl... [Read More]

Tracked on February 7, 2014 01:13 PM

» venus factor foods from venus factor foods
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 7, 2014 01:26 PM

» the venus factor book from the venus factor book
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 7, 2014 03:11 PM

» Repair Lucan from Repair Lucan
I'm interested in fashion and I want to start a blog but I have no idea where to start or how to get people interested in my blog. Any ideas welcome.. [Read More]

Tracked on February 7, 2014 03:29 PM

» venus factor reviews from venus factor reviews
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 7, 2014 05:05 PM

» https://www.rebelmouse.com/truthaboutcellulitejoeyatlas/ from https://www.rebelmouse.com/truthaboutcellulitejoeyatlas/
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 8, 2014 10:22 AM

» web advertising from web advertising
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 9, 2014 10:52 AM

» divorce will county from divorce will county
I have one computer running Vista which is connected to the internet and I want to be able to get the internet on my second computer (that's got XP) which is connected via a crossover cable. What do I need to set to be able to surf the net on my second... [Read More]

Tracked on February 9, 2014 11:38 AM

» Essential Driver Training Clondalkin from Essential Driver Training Clondalkin
I am trying to find a free Dreamweaver alternative and it looks like Kompozer is good. But I could not find any feedback with using this program for wordpress templates. I wanted to know if anyone has used it and how well it works. Thanks in advance.. [Read More]

Tracked on February 9, 2014 12:24 PM

» supplements ireland from supplements ireland
I need to start a free website and need information on where to go to get it started. Any info about starting a website is welcome!. [Read More]

Tracked on February 10, 2014 10:38 AM

» venus factor website from venus factor website
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 13, 2014 02:28 AM

» read the article from read the article
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 14, 2014 02:57 AM

» babyoye coupons from babyoye coupons
I would like to remove the blogger and designer links on the attribution bar at the bottom of a blogger page. I know its not good to remove it and usually i don't, but this is a page for a business so it needs to look clean and profesisonal.. [Read More]

Tracked on February 14, 2014 04:26 AM

» verizon fios double play or triple play promotion code from verizon fios double play or triple play promotion code
I have face major problem with my blog that it was not spam and blogger take my blog as spam....Can any one help me to recover my blog back.. [Read More]

Tracked on February 16, 2014 05:51 PM

» personalized dog collars from personalized dog collars
I've been looking high and low, and it seems that most liberal arts schools are populated by heavy drinkers and partiers, which I am not interested in. If I can, I'd like to double major in creative writing and journalism.. Thank you!. [Read More]

Tracked on February 16, 2014 09:47 PM

» lifetime website traffic" from lifetime website traffic"
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 16, 2014 11:09 PM

» homeowners insurance companies list from homeowners insurance companies list
I have a blog on Blogspot that I've been trying to customize with my own banner, but I can't seem to figure out where to do this :P A site where I could make a banner would be helpdul, too. If anyone has any directions they could give me to help me out... [Read More]

Tracked on February 17, 2014 12:30 AM

» moncler outlet from moncler outlet
Ugg prezzi [Read More]

Tracked on February 17, 2014 04:32 PM

» moncler outlet from moncler outlet
parajumpers outlet [Read More]

Tracked on February 17, 2014 04:32 PM

» Piumini Woolrich Italia from Piumini Woolrich Italia
Ugg shop online [Read More]

Tracked on February 17, 2014 04:32 PM

» jeux gratuit de casino from jeux gratuit de casino
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 17, 2014 05:05 PM

» jeux de casino gratuit sans telechargement from jeux de casino gratuit sans telechargement
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 17, 2014 06:34 PM

» Rudolph from Rudolph
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 17, 2014 07:14 PM

» machine a sous gratuit casino from machine a sous gratuit casino
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 17, 2014 08:30 PM

» Canada Goose from Canada Goose
Scarpe Hogan [Read More]

Tracked on February 17, 2014 10:46 PM

» lxw pro testosterone formula from lxw pro testosterone formula
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 20, 2014 01:27 PM

» granuflo attorney from granuflo attorney
What is the procedure to copyright a blog content (text and images)?. I wish to copyright the content on my blog (content and images)?? can anyone please guide as to how can i go abt it?. [Read More]

Tracked on February 21, 2014 01:50 PM

» Binary Options Trading Signals from Binary Options Trading Signals
How does one find out how to become a blogger, or how much a blogger makes? [Read More]

Tracked on February 22, 2014 10:24 AM

» website marketing from website marketing
I am new to blogging. How do I add a subscribe function to my site so new post will go to their email?. [Read More]

Tracked on February 23, 2014 10:54 AM

» Driving Lessons Balgriffin from Driving Lessons Balgriffin
I'm wondering how will I make my blog in blogspot available via google web search? I've seen some blogs that can easily be googled but mine won't show in google at all.. [Read More]

Tracked on February 24, 2014 09:25 AM

» http://couponman.in/stores/freecultr-coupons/ from http://couponman.in/stores/freecultr-coupons/
What would be a good college where I can major in creative writing? [Read More]

Tracked on February 24, 2014 09:58 AM

» Robert N. Faller from Robert N. Faller
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on February 25, 2014 05:47 AM

» Pizza Hut coupons from Pizza Hut coupons
What is the best software to design websites and blogs? [Read More]

Tracked on March 2, 2014 01:31 AM

» vpn benefits from vpn benefits
What is internet blogging and what is the best blog website? [Read More]

Tracked on March 7, 2014 10:23 AM

» BTGuard from BTGuard
Just started my own blog on Blogspot need help with header? [Read More]

Tracked on March 7, 2014 10:54 AM

» Learn More Here from Learn More Here
What is the best application for posting blogs or articles to my website? [Read More]

Tracked on March 8, 2014 09:29 AM

» SEO Services from SEO Services
How do you start building a WordPress site for an already existing website? [Read More]

Tracked on March 9, 2014 08:48 AM

» light bulbs from light bulbs
How many blog post should i have before i start promoting it? [Read More]

Tracked on March 13, 2014 02:17 AM

» garcinia cambogia extract reviews from garcinia cambogia extract reviews
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on March 13, 2014 11:57 PM

» dasuquin with msm for medium dogs from dasuquin with msm for medium dogs
It used to show at the top of my start list until I downloaded google chrome to see what it was all about, I didn't really like it so I deleted it but now firefox isnt at the top of start. Any ideas?. [Read More]

Tracked on March 14, 2014 12:38 AM

» individual retirement accounts from individual retirement accounts
I have a small background in magazine journalism but my new job requires no writing at all, except for emails. . . I would like to start doing some creative writing but I don't know where to start, as in, what do I write about, and whether it's actuall... [Read More]

Tracked on March 14, 2014 10:26 PM

» fortiflora canine houston tx from fortiflora canine houston tx
Want to detailed introductory course in creative writing-novel,short story,even plays and screenplays. Written before but not published and no formal training.. [Read More]

Tracked on March 15, 2014 09:52 PM

» social media contest from social media contest
How much money have you earned by blogging on the internet? [Read More]

Tracked on March 17, 2014 08:42 PM

» purina fortiflora for dogs from purina fortiflora for dogs
Where can I find the best online creative writing courses? [Read More]

Tracked on March 17, 2014 08:45 PM

» http://carinsurance.theclevergroup.com/ from http://carinsurance.theclevergroup.com/
Any one know how to get a free copyright for articles published in blogs..? [Read More]

Tracked on March 18, 2014 02:49 PM

» click here from click here
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on March 21, 2014 08:43 AM

» sexykarma.com from sexykarma.com
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on March 21, 2014 10:50 AM

» www.homeinsurance.theclevergroup.com/ from www.homeinsurance.theclevergroup.com/
Im curious about how much it costs to start websites such as Facebook or Twitter. I have been thinking about starting a website for a while now, but i feel as though the initial prices that website design firms give you are for a very low tech and spar... [Read More]

Tracked on March 21, 2014 02:06 PM

» image source from image source
Will Blogging content of Various Sites findings lead to copyright infringement, Will mentioning Source help? [Read More]

Tracked on March 24, 2014 07:52 AM

» different types of social media from different types of social media
What is the best way for a recent creative writing grad to get an agent? [Read More]

Tracked on March 28, 2014 01:44 AM

» www.businessinsurance.theclevergroup.com/ from www.businessinsurance.theclevergroup.com/
How can I personalize my blog without making it look like crap? [Read More]

Tracked on March 28, 2014 06:32 PM

» home appliance insurance from home appliance insurance
get the greatest small business insurance anywhere [Read More]

Tracked on March 28, 2014 07:29 PM

» cheap michael kors bags from cheap michael kors bags
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on March 29, 2014 03:11 PM

» credit card from credit card
Where can I get copyright free content to write blog on the net? [Read More]

Tracked on March 30, 2014 04:37 PM

» description from description
How can I make firefox to prompt me for what to do with a file instead of automatically downloading? [Read More]

Tracked on April 1, 2014 01:19 PM

» Cleanse Colon from Cleanse Colon
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on April 2, 2014 11:08 AM

» click through the up coming page from click through the up coming page
Data Discussions: Installing PostGIS and Postgres on Ubuntu [Read More]

Tracked on April 6, 2014 02:57 AM

» charity fundraising ideas from charity fundraising ideas
How can I keep up with posts made on the Blogspot websites? [Read More]

Tracked on April 10, 2014 09:20 PM

» swiss replica watches from swiss replica watches
i need some ideas for a blog. i already do poems and surveys on it but i wanna talk about something.. [Read More]

Tracked on April 15, 2014 10:45 AM

» unlock iphone 4 from unlock iphone 4
How do you delete media files with apostrophes from Joomla? [Read More]

Tracked on April 16, 2014 06:35 AM

Comments

Login to leave a comment. Create a new account.