<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name="Microsoft Theme 2.00" content="Untitled.htm 011">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h1
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:24.0pt;
font-family:"Times New Roman";
font-weight:bold;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
span.textblue1
{font-family:Verdana;
color:#005B7F;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:298851747;
mso-list-template-ids:1783781234;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1
{mso-list-id:1150288349;
mso-list-type:hybrid;
mso-list-template-ids:-419776546 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l1:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l1:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I am new to postgreSQL and I have the following problem while trying to
follow the setup process for the postgreSQL in Windows,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>After installing the PostgreSQL and creating a new role and database I
have tried to install the pl/Java but it shows the following error<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I used the below mentuioned command and it shos the error <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>C:\Program Files\PostgreSQL\8.1\bin>java -cp
..\share\pljava\deploy.jar;..\jdbc\<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>postgresql-8.1-405.jdbc3.jar org.postgresql.pljava.deploy.Deployer
-install -use<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>r compiere -database compiere -password compiere<o:p></o:p></span></font></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'>org.postgresql.util.PSQLException:
ERROR: could not load library "C:/Program Fil<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'>es/PostgreSQL/8.1/lib/libpljava.dll":
Access is denied.<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>ecutorImpl.java:1512)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Impl.java:1297)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>va:188)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>ement.java:437)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Jdbc2Statement.java:339)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>ement.java:331)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> at
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>432)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> at
org.postgresql.pljava.deploy.Deployer.main(Deployer.java:275)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'>Process I followed for the
Installation Process<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<ol style='margin-top:0in' start=1 type=1>
<li class=MsoNormal style='mso-list:l1 level1 lfo1'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'>In
the %Path% of the Environment variables I have given the values <o:p></o:p></span></font></b></li>
</ol>
<p style='margin-left:.25in'><font size=2 face=Verdana><span style='font-size:
10.0pt;font-family:Verdana'>c:\Program Files\Java\jdk1.5.0_07\lib;<br>
C:\Program Files\Java\jdk1.5.0_07\bin;<br>
C:\Program Files\Java\jdk1.5.0_07\jre\bin\client;<br>
C:\Program Files\Java\jdk1.5.0_07\jre\bin;<br>
C:\Program Files\PostgreSQL\8.1\bin;<br>
c:\Program Files\PostgreSQL\8.1\lib;</span></font><o:p></o:p></p>
<ol style='margin-top:0in' start=2 type=1>
<li class=MsoNormal style='mso-list:l1 level1 lfo1'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'>After
that I have followed the process to install from Step 2 given below.</span></font></b>
<b><span style='font-weight:bold'><o:p></o:p></span></b></li>
</ol>
<p class=MsoNormal style='margin-left:.25in'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<ol style='margin-top:0in' start=3 type=1>
<li class=MsoNormal style='mso-list:l1 level1 lfo1'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'>After
installation of the PostgreSQL I have craeted a New Role and Database
successfully by using the Command Prompt in the PostGreSQL (Refer Diag:1)
as Given in the Step 3.</span></font></b> <b><span style='font-weight:
bold'><o:p></o:p></span></b></li>
</ol>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<ol style='margin-top:0in' start=4 type=1>
<li class=MsoNormal style='mso-list:l1 level1 lfo1'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'>After
thst I have cchanged the file </span></font></b><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>postgresql.conf with the
below mentioned details</span></font> <b><span style='font-weight:bold'><o:p></o:p></span></b></li>
</ol>
<p style='margin-left:.75in'><font size=2 face=Verdana><span style='font-size:
10.0pt;font-family:Verdana'>custom_variable_classes = 'pljava'<br>
pljava.classpath = 'C:\\Program Files\\PostgreSQL\\8.1\\share\\pljava\\pljava.jar'
<br>
pljava.release_lingering_savepoints = true<br>
pljava.vmoptions = '-Xmx64M -Dbackchannel.port=48'<br>
pljava.debug = false<o:p></o:p></span></font></p>
<p style='margin-left:.5in;text-indent:-.25in;mso-list:l1 level1 lfo1'><![if !supportLists]><b><font
size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana;
font-weight:bold'><span style='mso-list:Ignore'>5.<font size=1
face="Times New Roman"><span style='font:7.0pt "Times New Roman"'>
</span></font></span></span></font></b><![endif]><b><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;font-weight:bold'>After that I have
tried to <st1:Street w:st="on"><st1:address
style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
tabIndex="0" w:st="on">Install PL</st1:address></st1:Street>/Java by using the
command.<o:p></o:p></span></font></b></p>
<p style='margin-left:.25in;text-indent:.25in'><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>C:\Program
Files\PostgreSQL\8.1\bin>java -cp ..\share\pljava\deploy.jar;..\jdbc\postgresql-8.1-405.jdbc3.jar
org.postgresql.pljava.deploy.Deployer -install -user compiere -database
compiere -password Compiere<o:p></o:p></span></font></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>
<b><span style='font-weight:bold'>But when trying to run the command in the
Command Prompt in the Diagram given below<o:p></o:p></span></b></span></font></p>
<p style='margin-left:.25in;text-indent:.25in'><b><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;font-weight:bold'><img width=539
height=375 id="_x0000_i1033" src="cid:image001.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></b></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>But in
the console it showed the error message <o:p></o:p></span></font></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'>org.postgresql.util.PSQLException:
ERROR: could not load library "C:/Program Fil<o:p></o:p></span></font></b></p>
<p class=MsoNormal><b><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;font-weight:bold'>es/PostgreSQL/8.1/lib/libpljava.dll":
Access is denied.<o:p></o:p></span></font></b></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Please
suggest me the solution for the problem I am trying to solve this for the past
two days by so many ways , but nothing is working,So please help me to solve
this problem.<o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-left:.25in'><b><font size=3
face="Times New Roman"><span style='font-size:12.0pt;font-weight:bold'><o:p> </o:p></span></font></b></p>
<table class=MsoNormalTable border=0 cellpadding=0 width="98%"
style='width:98.0%'>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><b><font size=4 face="Times New Roman"><span
style='font-size:14.0pt;font-weight:bold'>These are the Steps for Installing
the PostgreSQL in my System<o:p></o:p></span></font></b></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt;display:none'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellspacing=3 cellpadding=0 width="96%"
style='width:96.0%'>
<tr>
<td style='padding:3.75pt 3.75pt 3.75pt 3.75pt'>
<h1><b><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>PostgreSQL
Installation in Windows (with PL/Java) for the Compiere<o:p></o:p></span></font></b></h1>
</td>
</tr>
<tr>
<td valign=top style='padding:3.75pt 3.75pt 3.75pt 3.75pt'>
<p><strong><b><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>1) Preparation </span></font></b></strong><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>Fill
the following values in path:</span></font><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'><br>
c:\<<pathjava>>\lib;<br>
C:\<<pathjava>>\bin;<br>
C:\<<pathjava>>\jre\bin\client;<br>
C:\<<pathjava>>\jre\bin;<br>
C:\<<pathpg>>\8.1\bin;<br>
c:\<<pathpg>>\8.1\lib;</span></font><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>where,</span></font><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'><<pathjava>>
= java installation path<br>
<<pathpg>> = postgresql installation path</span></font><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>In
my example:</span></font><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>c:\Program
Files\Java\jdk1.5.0_07\lib;<br>
C:\Program Files\Java\jdk1.5.0_07\bin;<br>
C:\Program Files\Java\jdk1.5.0_07\jre\bin\client;<br>
C:\Program Files\Java\jdk1.5.0_07\jre\bin;<br>
C:\Program Files\PostgreSQL\8.1\bin;<br>
c:\Program Files\PostgreSQL\8.1\lib;</span></font><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p><strong><b><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>2) PostgreSQL Installation</span></font></b></strong><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>Run
the PostgreSQL Installer and follow the instructions according pictures.</span></font><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=506 height=392 id="_x0000_i1034"
src="cid:image002.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=506 height=392 id="_x0000_i1035"
src="cid:image003.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><em><i><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>If
the option Pl/Java is unchecked checked it.</span></font></i></em><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=506 height=392 id="_x0000_i1036"
src="cid:image004.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><em><i><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>If
the option Development is unchecked checked it.</span></font></i></em><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=506 height=392 id="_x0000_i1037"
src="cid:image005.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><em><i><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>This
windows is about install PostgreSQL as windows service.</span></font></i></em><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=467 height=126 id="_x0000_i1038"
src="cid:image006.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><em><i><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>If
postgres user not exists, then installer make it.</span></font></i></em><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=506 height=392 id="_x0000_i1039"
src="cid:image007.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><em><i><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Creation
PostgreSQL superuser, encoding configuration and security configuration. </span></font></i></em><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=638 height=146 id="_x0000_i1040"
src="cid:image008.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><em><i><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Is
the network access option is checked in previous window, this window is
displayed.</span></font></i></em><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=506 height=392 id="_x0000_i1041"
src="cid:image009.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=506 height=392 id="_x0000_i1042"
src="cid:image010.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=506 height=392 id="_x0000_i1043"
src="cid:image011.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><em><i><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Next</span></font></i></em><o:p></o:p></p>
<p><strong><b><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>3) Database creation</span></font></b></strong><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>Follow
the instructions according pictures:</span></font><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=669 height=338 id="_x0000_i1044"
src="cid:image012.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><em><i><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Create
database compiere user.</span></font></i></em><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=669 height=338 id="_x0000_i1045"
src="cid:image013.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><em><i><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>Database
creation.</span></font></i></em><o:p></o:p></p>
<p><strong><b><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>4) PlJava Installation</span></font></b></strong><o:p></o:p></p>
<p><strong><b><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>4.1) Configuration</span></font></b></strong><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>-
Open the <<pathpg>>/data/postgresql.conf<br>
- Type in the end file:</span></font><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>custom_variable_classes
= 'pljava'<br>
pljava.classpath = 'C:\\Program
Files\\PostgreSQL\\8.1\\share\\pljava\\pljava.jar' <br>
pljava.release_lingering_savepoints = true<br>
pljava.vmoptions = '-Xmx64M -Dbackchannel.port=48'<br>
pljava.debug = false</span></font><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>IMPORTANT:
Restart PostgreSQL</span></font><o:p></o:p></p>
<p><strong><b><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>4.2) PL/Java Installation in PostgreSQL</span></font></b></strong><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=669 height=338 id="_x0000_i1046"
src="cid:image014.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><em><i><font size=3 face="Times New Roman"><span style='font-size:12.0pt'>This
option will install the pl/java functions in compiere database. Attemption to
the deploy.jar and postgresql-8.1-405.jdbc3 path.</span></font></i></em><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<p><strong><b><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>4.3) Installing Compiere Functions in Database </span></font></b></strong><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>-
psql -U compiere compiere<br>
- CREATE SCHEMA compiere;<br>
- SET search_path TO compiere,sqlj;<br>
- SELECT sqlj.install_jar('file:///c:\\Compiere2\\lib\\sqlj.jar', 'sqlj',
true);<br>
- SELECT sqlj.set_classpath('compiere', 'sqlj');</span></font><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><img
width=669 height=480 id="_x0000_i1047"
src="cid:image015.jpg@01C7A3B2.9F519AA0"><o:p></o:p></span></font></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'><br>
<strong><b><font face=Verdana><span style='font-family:Verdana'>5) Import
Compiere Dump</span></font></b></strong></span></font><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>psql
-U compiere compiere -f C:\Compiere2\data\CompierePG.sql</span></font><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p><strong><b><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>6) Checking </span></font></b></strong><o:p></o:p></p>
<p><font size=2 face=Verdana><span style='font-size:10.0pt;font-family:Verdana'>Open
the PGAdmin program and verify the following parameters in schemas of
compiere database:</span></font><o:p></o:p></p>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level1 lfo2'><strong><b><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>Compiere Schema:</span></font></b></strong>
<o:p></o:p></li>
<ul type=circle>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo2'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Functions: 66 <o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo2'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Operators: 2 <o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo2'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Tables: 522 (approximate) <o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo2'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Views: 108 <o:p></o:p></span></font></li>
</ul>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level1 lfo2'><strong><b><font size=2 face=Verdana><span
style='font-size:10.0pt;font-family:Verdana'>Sqlj Schema</span></font></b></strong>
<o:p></o:p></li>
<ul type=circle>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo2'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Functions: 9 <o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo2'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Sequences: 2 <o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo2'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Tables: 3 (or for according PostgreSQL
version) <o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo2'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Records in classpath_entry table: 1 <o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo2'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Records in jar_entry table: 8 <o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level2 lfo2'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Records in jar_repository table: 1 <o:p></o:p></span></font></li>
</ul>
</ul>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt;display:none'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellpadding=0 width="98%"
style='width:98.0%'>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt;display:none'><script type="text/javascript">
<!--
google_ad_client = "pub-1823529327727920";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "text_image";
google_ad_channel ="";
//-->
</script><script src="Compiere - PostgreSQL Installation in Windows (with PL-Java) for the Compiere_files/show_ads.js" type="text/javascript">
</script></span><o:p> </o:p></font></p>
</td>
</tr>
<iframe name="google_ads_frame" marginwidth=0 marginheight=0
src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-1823529327727920&dt=1180609701609&lmt=1180441609&prev_fmts=468x60_as&format=468x60_as&output=html&correlator=1180609701109&url=file%3A%2F%2F%2FC%3A%2FTenthPlanet%2FManikandan%2FCompiere%2520-%2520PostgreSQL%2520Installation%2520in%2520Windows%2520(with%2520PL-Java)%2520for%2520the%2520Compiere.htm&ad_type=text_image&cc=8&flash=9&u_h=768&u_w=1024&u_ah=740&u_aw=1024&u_cd=32&u_tz=330&u_java=true"
frameborder=0 width=468 scrolling=no height=60 allowTransparency>
</iframe>
<!--
<table width="100%" border="0">
<tr>
<td class="busca" width="27%">Busca:</td>
<td><input class="caixa-de-texto" type="text" name="busca" style="width:90px;"></td>
<td><input type="button" class="botao" name="busca" style="width:2 0px;" value="OK"></td>
</tr>
</table>-->
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>