postgresql installation

Repository Setup

In order to do even minimal changes to a standard postgresql deploy (like install postGIS) you must be sure you have control of where you get your packages. This is not as straight forward as it should be. I encourage you to take a few minutes to read this through. First, your "disto repository" is not likely to be up to date with respect to postgresql packages. In other words, if you blindly type "yum install postgresql-devel", you may have trouble getting everything installed properly. I've seen errors regarding missing libraries and the like. To avoid the fuss, when you are installing postgresql packages, use the postgresql repositories instead of your ditsro repsository.

Here is how you do that. You should read this from top to bottom.

• http://yum.pgsqlrpms.org/howtoyum.php

Also read this; you can safley skip sections on this page.

• http://www.postgresonline.com/journal/index.php?/archives/45-An-Almost-Idiots-Guide-to-PostgreSQL-YUM.html

Did you do your reading?

Installation

We want to install postgresql 8.3.7 for CentOS release 5.5, 64 bit (x86_64).
This is a good how to:

• http://postgis.refractions.net/docs/ch02.html

todo - add Summco directions here

Errors

Errors we've seen

error:

  configure: error: no acceptable C compiler found in $PATH

solution:

yum install gcc-c++

error: 

configure: error: readline library not found

solution:

yum install readline-devel.x86_64

error: 

configure: error: zlib library not found

solution:

yum install zlib.x86_64 zlib-devel.x86_64