PostgreSQL installation for koosseryADempiere_EN.pdf

arizonahoopleΔιαχείριση Δεδομένων

28 Νοε 2012 (πριν από 4 χρόνια και 10 μήνες)

365 εμφανίσεις

PostgreSQL installation or the project koosseryADempiere
Technical Document N°4

1


"People & Technology for your Agility & Performance"
.
Conseil et Ingénierie Informatique.
www.koossery-tech.fr



Cameroon : Douala, Akwa, BP 12415
France : 9 Rue Hanoi- 69100 Villeurbanne

Email :
ktechlab@koossery-tech.com


August 2009


PostgreSQL installation for the project
koosseryADempiere



PostgreSQL installation or the project koosseryADempiere
Technical Document N°4

2

1 Introduction................................................................................................................................................3
1.1 Object.................................................................................................................................................3
1.2 Definitions, acronyms and abbreviations........................................................................................3
2 Installation de PostgreSQL.........................................................................................................................4
2.1.1 Requirements..................................................................................................................................4
2.1.2 Steps...............................................................................................................................................4
2.1.2.1 JRE, JDK...............................................................................................................................4
2.1.2.2 JAVA_HOME, JRE_HOME.................................................................................................4
2.1.2.3 PostgreSQL installation.........................................................................................................5
2.2 Specifying the location of the database...........................................................................................7
3 Conclusion..................................................................................................................................................8
PostgreSQL installation or the project koosseryADempiere
Technical Document N°4
3

1 Introduction
1.1 Object
PostgreSQL is an open source SGBD, available at this address
http://www.postgresql.org/download/
. Download 8.2. Version
1.2 Definitions, acronyms and abbreviations
Abréviation
Signification
JDK Java Developpment Kit
JRE Java Runtime Environment





PostgreSQL installation or the project koosseryADempiere
Technical Document N°4

4

2 Installation de PostgreSQL
2.1.1 Requirements
• JDK 5
• JRE 6
• PostgreSQL 8.2.11
2.1.2 Steps
2.1.2.1 JRE, JDK
Check that your have JDK 5 and JRE 6 installed
2.1.2.2 JAVA_HOME, JRE_HOME
Set the following environment variables if they are not already be done
Start->Right clic on Station,￿ Properties￿ Avanced Tab ￿ environnement. Variables

PostgreSQL installation or the project koosseryADempiere
Technical Document N°4

5


Figure 1 Propriétés Systèmes JRE, JDK
Also ensure that the following paths are part of the PATH:%JRE_HOME%\bin
%JRE_HOME%\bin\client
%JAVA_HOME%
2.1.2.3 PostgreSQL installation
After recovering the 8.2.11 version of PostgreSQL, do the following:
• Extract the archive
• Run the executable while ensuring in the process of activating the extension pljava

PostgreSQL installation or the project koosseryADempiere
Technical Document N°4

6


Figure 2 Activation pljava

When the package is activated, the following screen appears generally as follows

Any configuration other than this with the box unchecked means that the pljava is not
installed. In this case, review the environment variables in the previous section. Once
installation is complete:
• Add PG_HOME environment variable pointing to the folder on the installation of
PostgreSQL
• Update the PATH to the bin folder of PostgreSQL. PG_HOME%% \ bin


PostgreSQL installation or the project koosseryADempiere
Technical Document N°4

7

2.2 Specifying the location of the database
￿ Once the installation is complete, stop the service Postgres Database
Server 8.2
￿ Move all the contents of data directory setup in the new location that
is to say F: / Data / PostgreSQL

￿ Go in regedit
HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \
pgsql-8.2 and change the Image Path string "C: \ Program Files \
PostgreSQL \ 8.1 \ bin \ pg_ctl.exe" runservice-N "pgsql-8.2"-D "C: \
Program Files \ PostgreSQL \ 8.2 \ data \ " in
"C: \ Program Files \ PostgreSQL \ 8.2 \ bin \ pg_ctl.exe" runservice-
N "pgsql-8.2"-D "F: \ Data \ PostgreSQL \"
￿ Into HKEY_LOCAL_MACHINE \ SOFTWARE \ PostgreSQL \ Services
\ pgsql-8.2 change the Data Directory string specifying the new
location F: \ Data \ PostgreSQL

￿ Into HKEY_LOCAL_MACHINE \ SOFTWARE \ PostgreSQL \
Installations \ (GUID) edit Channel Data Directory always specifying
the new location F: \ Data \ PostgreSQL

￿ Before you restart the service, you must give write permissions on
the new location to user postgres example using this command:
cacls D: \ Data \ PostgreSQL / T / E / G postgres: C

￿ Restart the Postgres Database Server 8.2

￿ Start by running PostgreSQL pgAdmin III.

PostgreSQL installation or the project koosseryADempiere
Technical Document N°4

8

3 Conclusion
For more information
http://www.postgresql.org