PostgreSQL Installation in Windows (with PL/Java) for the Compiere

1) Preparation

Fill the following values in path:


c:\<<pathjava>>\lib;
C:\<<pathjava>>\bin;
C:\<<pathjava>>\jre\bin\client;
C:\<<pathjava>>\jre\bin;
C:\<<pathpg>>\8.1\bin;
c:\<<pathpg>>\8.1\lib;

where,

<<pathjava>> = java installation path
<<pathpg>> = postgresql installation path

In my example:

c:\Program Files\Java\jdk1.5.0_07\lib;
C:\Program Files\Java\jdk1.5.0_07\bin;
C:\Program Files\Java\jdk1.5.0_07\jre\bin\client;
C:\Program Files\Java\jdk1.5.0_07\jre\bin;
C:\Program Files\PostgreSQL\8.1\bin;
c:\Program Files\PostgreSQL\8.1\lib;

2) PostgreSQL Installation

Run the PostgreSQL Installer and follow the instructions according pictures.

If the option Pl/Java is unchecked checked it.


If the option Development is unchecked checked it.


This windows is about install PostgreSQL as windows service.

If postgres user not exists, then installer make it.

Creation PostgreSQL superuser, encoding configuration and security configuration.

Is the network access option is checked in previous window, this window is displayed.

Next

3) Database creation

Follow the instructions according pictures:

Create database compiere user.

Database creation.

4) PlJava Installation

4.1) Configuration

– Open the <<pathpg>>/data/postgresql.conf
– Type in the end file:

custom_variable_classes = ‘pljava’
pljava.classpath = ‘C:\Program Files\PostgreSQL\8.1\share\pljava\pljava.jar’
(ou o caminho correto do seu PostgreSQL)
pljava.release_lingering_savepoints = true
pljava.vmoptions = ‘-Xmx64M -Dbackchannel.port=48’
pljava.debug = false

IMPORTANT: Restart PostgreSQL

4.2) PL/Java Installation in PostgreSQL

This option will install the pl/java functions in compiere database.
Attemption to the deploy.jar and postgresql-8.1-405.jdbc3 path.

4.3) Installing Compiere Functions in Database

– psql -U compiere compiere
– CREATE SCHEMA compiere;
– SET search_path TO compiere,sqlj;
– SELECT sqlj.install_jar(‘file:///c:\\Compiere2\\lib\\sqlj.jar’, ‘sqlj’, true);
– SELECT sqlj.set_classpath(‘compiere’, ‘sqlj’);


5) Import Compiere Dump

psql -U compiere compiere -f C:\Compiere2\data\CompierePG.sql

6) Checking

Open the PGAdmin program and verify the following parameters in schemas of compiere database:

  • Compiere Schema:
    • Functions: 66
    • Operators: 2
    • Tables: 522 (approximate)
    • Views: 108
  • Sqlj Schema
    • Functions: 9
    • Sequences: 2
    • Tables: 3 (or for according PostgreSQL version)
    • Records in classpath_entry table: 1
    • Records in jar_entry table: 8
    • Records in jar_repository table: 1

Tentang Oka Wirasatha

Focus, Mandiri dan Konsisten
Pos ini dipublikasikan di database, ERP dan tag . Tandai permalink.

Satu Balasan ke PostgreSQL Installation in Windows (with PL/Java) for the Compiere

  1. Oscar Cano R berkata:

    I intented install Adempier, but in point 5
    5) Import Compiere Dump

    psql -U compiere compiere -f C:\Compiere2\data\CompierePG.sql

    Don’t exist file “*.sql” in this path.

    Can you help me

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s