Install PostgreSQL with PL/Java on Windows
Prerequisites
- Installed JDK 5.0
- Download the PostgreSQL installer zip file (e.g. postgresql-8.1.4-1.zip) and extract the contents to a local directory
Installation Steps
1. Doublecklick the Windows installer (e.g. postgresql-8.1.msi)
Choose your installation language and click Start.
2. Greeting
Close all Windows applications and click Next.
3. Installation Notes
Click Next.
4. Installation Options
Choose PL/Java (and maybe National language support) and click Next.
5. Service Configuration
Leave Install as a service checked, choose a password for the OS user account and click Next.
6. Initialise database cluster
Make the following entries:
- Leave Initialize database cluster checked
- check Accept connections on all addresses not just localhost
- choose your locale
- set Encoding to UTF-8
- choose a password for the database Superuser
Click Next.
7. Enable procedural languages
Leave PL/pgsql checked and additionally check PL/java. Click Next.
8. Enable contrib modules
Click Next.
9. Ready to install
Click Next.
10. Installating...
11. Installation complete!
Click Finish.
12. Configuration: Client Authentication
Enable client connections from the network.
Open the pg_hba.conf server configuration from pgAdmin III and add an acivated line as in the example above, to allow client connections from the network. (In the example above all connections from hosts 192.168.*.* are allowed to connect to all databases unconditionally. You will have to change the IP address range according to your network structure.) See the PostgreSQL documentation for a detailed explanation and examples.
The corresponding line in pg_hba.conf would be
host all all 192.168.0.0/16 trust