...
While we developed EAS under postgresql 8.3.7, installing 8.3.7 was giving us trouble.
Therefore we upgraded to 8.3.11 which was available in via YUM and once we used YUM the install went smoothly.
The OS is CentOS release 5.5, 64 bit (x86_64).Using YUM is the way to go.
Once you have YUM configured to use only the postgres respositories and not the Centos repos,
follow these steps for a pain free installation:
| Code Block |
|---|
yum install postgresql
yum install postgresql-devel
yum install postgresql-server
yum install postgis
yum install postgresql-contrib
|
...
- http://wiki.postgresql.org/wiki/YUM_Installation
- http://www.postgresonline.com/journal/archives/45-An-Almost-Idiots-Guide-to-PostgreSQL-YUM.html
Initializing Database
Our Oracle trained DBAs decided to intialize the DB here
| Code Block |
|---|
/ur01/pgsql/data
|
Then we want to create 2 databases.
| Code Block |
|---|
createdb mad --owner postgres
createdb sfmaps --owner postgres
|
At this point, you can use pg_restore.
For more on that read
http://eas.googlecode.com/svn/trunk/releases/1_0_prod/README
Links
- http://www.postgresql.org/docs/8.3/static/creating-cluster.html
- http://www.postgresql.org/docs/8.3/static/runtime-config-file-locations.html
- http://archives.postgresql.org/pgsql-admin/2007-05/msg00104.php
Security
This is my best guess on security and users - feel free to recommend alternatives.
To get things simply to work, I modified hba.conf and postgresql.conf.
I am allowing all the postgres user to connect from localhost and from geoserver and from the web server.
The dataserver should be accessible only from the following:
...