Postgres Installation Guide

From Fenix

Revision as of 14:32, 14 November 2008 by Francesca (Talk | contribs)
(diff) ←Older revision | Current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search

The following steps will install the Postgres and PostGIS Database for the Workstation. The PostGres installer should launch automatically after step 7 of the Workstation installation procedure.

PostGres Installation

Image:Postgres8.3_installer_step1.JPG

  • Click Start


Image:Postgres8.3_installer_step2.JPG

  • Click Next


Image:Postgres8.3_installer_step3.JPG

  • Click Next


Image:Postgres8.3_installer_step4.JPG

  • Click Next
  • Name the service name and the account name as you like. Leave the other fields blank. This screen will come up

Image:Postgres8.3_installer_step5.JPG

  • Click Next


Image:Postgres8.3_installer_step6.JPG

  • The installer informs you that a password has been generated. Be sure to write down the account name and password for your own administration! Future upgrade may require it as well.
  • Click Next


Image:Postgres8.3_installer_step7.JPG

  • In the next screen select the UTF-8 encoding and enter the password. Other defaults don't need to be changed. Please remember your Postgres user name and password as this will be used later on in the installation.
  • Click Next
  • If you encounter this error as shown below, please refer to the FAQ for the solution

Image:Postgres-error1.jpg


Image:Postgres8.3_installer_step8.JPG

  • Click Next


Image:Postgres8.3_installer_step9.JPG

  • Click Next


Image:Postgres8.3_installer_step10.JPG

  • Click Next


Image:Postgres8.3_installer_step11.JPG

  • Click Finish


PostGIS Installation

PostGIS is now included as part of the new PostgreSQL StackBuilder architecture. The latest version can be installed by going to Start -> Programs -> PostgreSQL 8.3 -> Application Stack Builder.

Image:Postgis_installer_shortcut.JPG


  • Select your PostgreSQL installation from the list and then click "Next". The latest version of PostGIS will appear under the "Spatial Extensions" category.


Image:Postgres8.3_installer_step11b.JPG

  • Click Next


Image:Postgres8.3_installer_step12.JPG

  • Check on PostGIS 1.3.3 for PostgreSQLv8.3.3 Click Next


Image:Postgres8.3_installer_step13.JPG

  • Select any mirror site. Click Next.


Image:Postgres8.3_installer_step14.JPG

  • Click Next


Image:Postgres8.3_installer_step15.JPG

  • Click Next


Image:Postgres8.3_installer_step16.JPG

  • Click I Agree


Image:Postgres8.3_installer_step17.JPG

  • Click Next


Image:Postgres8.3_installer_step18.JPG

  • Click Next


Image:Postgres8.3_installer_step19.JPG

  • Click Next


Image:Postgres8.3_installer_step20.JPG

  • Click Install


Image:Postgres8.3_installer_step21.JPG

  • Click Close


Image:Postgres8.3_installer_step22.JPG

  • Click Finish, you should now be returned to the next screen of the Workstation installation.
Retrieved from "http://ldvapp07.fao.org:8031/FenixUserWiki/index.php/Postgres_Installation_Guide"