postgresql 8.3.7 installation...use the password you created during postgresql installation for...
TRANSCRIPT
![Page 1: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/1.jpg)
PostgreSQL 8.3.7 Installation - √
Install PostgreSQL 8.3.7-1 - √
![Page 2: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/2.jpg)
Installation Directory = C:\Program Files (x86)\PostgreSQL\8.3
![Page 3: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/3.jpg)
Data Directory = C:\Program Files (x86)\PostgreSQL\8.3\data
You need to remove your older \data folder (C:\Program Files (x86)\PostgreSQL\8.3\data), then this error will go away.
![Page 4: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/4.jpg)
Password = leica
Port = 5432
![Page 5: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/5.jpg)
Locale = “English, United States”
![Page 6: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/6.jpg)
![Page 7: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/7.jpg)
Install PostGIS 1.3.6 Extension from Stack Builder - √
If you want to install PostGIS extension offline, you can download the installer from http://pgfoundry.org/frs/?group_id=1000256&release_id=1274
Choose “PostgreSQL 8.3 on port 5432” to start with.
![Page 8: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/8.jpg)
NOTE: PostGIS 1.4.0 should also work!
Choose “PostGIS” from Spatial Extensions
![Page 9: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/9.jpg)
Choose an connection site, and click “Next”
![Page 10: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/10.jpg)
![Page 11: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/11.jpg)
Use the password you created during PostgreSQL installation for superuser.Password = leica
If you provide the wrong password, PostGIS database creation will fail. So you have to start the “Stack Builder” and install PostGIS extension again.
![Page 12: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/12.jpg)
![Page 13: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/13.jpg)
Done!
![Page 14: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/14.jpg)
Configure PostgreSQL & PostGIS - √
[1] Allow remote IP address to access PostgreSQLEdit <POSTGRES_HOME>/data/pg_hba.conf (C:\Program Files\PostgreSQL\8.3\data\pg_hba.conf)
Change from:
# IPv4 local connections:host all all 127.0.0.1/32 md5# IPv6 local connections:#host all all ::1/128 md5
To:
# IPv4 local connections:host all all 0.0.0.0/0 md5# IPv6 local connections:#host all all ::1/128 md5
[2] Allow communication over TCP/IP from All addressesEdit <POSTGRES_HOME>/data/postgresql.conf (C:\Program Files\PostgreSQL\8.3\data\postgresql.conf)
Change from:#listen_addresses = 'localhost' # what IP address(es) to listen on;to:listen_addresses = '*'
[3] Restart PostgreSQL service
NOTE:If you can not restart PostgreSQL, maybe the JAVA messed up (you uninstall one of the JRE, which destroy dependency.)So you need to uninstall all your JAVA JREs, and then install the newest JRE.You will be fine!
Create User Database for EAS/EAIM 2010 - √
Start the pgAdmin III from “Start->Programs->PostgreSQL 8.3->pgAdmin III”.You should have 3 databases created for you. We need to create a new database so that this database is where the EAS/EAIM catalog table will be stored
![Page 15: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/15.jpg)
Create database for EAS/EAIM 2010:Right click on the Database, and choose “New Database...”
From Properties Tab:Name = This is the database name you want to access it as (For example, EAIM_Catalog)Owner = Leave the owner as "postgres" if multiple people are going to be connecting to the databaseTemplate = Make sure to use "template_postgis" to enable Spatial support
![Page 16: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/16.jpg)
From Privileges Tab:Make sure you add the users you want to be able to access. At least Create, Temp and Connect privileges are required for EAIM
![Page 17: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/17.jpg)
Click OK to create the new database:
![Page 18: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/18.jpg)
Create Login Role for EAS/EAIM 2010 - √
Create Login role:
Right-click on the “Login Roles”, and choose “New login role...”From Properties Tab:Role Name = This is the role you will give your schemaPassword = give a passwordRole Privileges = make sure at least grant “Can create database objects” privilege.
![Page 19: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/19.jpg)
EAIM_2010/leica
Click OK, now you should have the new login role “EAIM_2010”:
![Page 20: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/20.jpg)
Create Schema for EAS/EAIM 2010 - √
Create New Schema for database “EAIM_CATALOG”:Right click on “Database->EAIM_CATALOG”, and choose “New Schema”:
From Properties Tab:Name = This is the name for your schemaOwner = choose “EAIM_2010” login role you just created
![Page 21: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/21.jpg)
Click OK, Now you should have your new Schema “EAIM_2010”:
![Page 22: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/22.jpg)
EAIM 2010 Installation
JDK v.1.5_14 or Higher - √
You can have multiple JDKs, only JDK 1.5_14 is tested!
Why you need JDK instead of JRE?This JDK is not for EAIM, JDK is for your web server (Tomcat or JBOSS);The difference between JDK and JRE is not only the java compiler (javac), JDK provide more library
![Page 23: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/23.jpg)
than JRE.... so JDK is always recommend for Server stuff (JRE is fine for Client stuff).
EAIM will use its own JDK.
Environment Variables - √
Make sure you set up the following System Environment Variables:
JAVA HOME = C:\Program Files\Java\jdk1.5.0_14
See the following Screen Shots:
Note: I use Window 2003 server 64bit, so the Java installation folder is C:\Program Files (x86)\Java\
Install JAI - √
See the “Install JAI” from PostgreSQL 8.3 based EAIM
https://jai.dev.java.net/binary-builds.html#Release_buildsLooking for JAI 1.1.3 (for Windows-i586)
![Page 24: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/24.jpg)
JAI will look for JAVA_HOME, and then copy its library to JAVA_HOME
Install EAIM 2010 Server - √
![Page 25: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/25.jpg)
![Page 26: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/26.jpg)
Old
Interface:
![Page 27: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/27.jpg)
![Page 28: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/28.jpg)
![Page 29: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/29.jpg)
Note: Please use the full host name instead of IP address for the Server name.
Note:Click Yes, if this is your first time to install EAIM on your system. If you want to keep your older catalog table (from EAIM 9.3.2), click No.If you have older catalog table (previous EAIM 9.3 or EAM 9.3.1), you need to migrate them to the new catalog system.
![Page 30: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/30.jpg)
![Page 31: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/31.jpg)
![Page 32: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/32.jpg)
![Page 33: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/33.jpg)
Installation will automatically deploy the webapp to embedded JOBSS server:You should have the following file structure:
![Page 34: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/34.jpg)
Check the PostgreSQL, and you will see the catalog tables (25 tables) are created for you:
![Page 35: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/35.jpg)
Install Data Manager 2010 - √
![Page 36: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/36.jpg)
![Page 37: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/37.jpg)
![Page 38: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/38.jpg)
![Page 39: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/39.jpg)
Test - √
Start JBOSS server.
C:\Program Files (x86)\ERDAS\APOLLO_postgresql\jboss\bin\run.bat
Start Data Manager
Connect to EAIM JBOSS server:
![Page 40: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/40.jpg)
admin/apollo123
Crawl some dataset:
![Page 41: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/41.jpg)
Start EAIM Web Client:
![Page 42: PostgreSQL 8.3.7 Installation...Use the password you created during PostgreSQL installation for superuser. Password = leica If you provide the wrong password, PostGIS database creation](https://reader033.vdocuments.us/reader033/viewer/2022060512/5f2b29d2db2d3b7840355213/html5/thumbnails/42.jpg)