installation_win7pro1
Installing PostgreSQL in windows 7 Professional
Step:1

Pick a location

directory of storing data

Step:2 Setting password: postgre_manas9 (in windows 7 professional /manas14pc) to keep password and code

choosing a port

cluster

Step:3 Installation complete

Step:4 Using stack builder to pick additional items

pgAgent, and pgboundcer :

pgbopuncer supports sever type of pooling connection like session pooling, transaction pooling and statement pooling, and some command line switches for windws and unix.

Some web  tools, like apache server and phpPgAdmin. ince I am using windows II6 / FastCGI environment I would skip these two.

Step:5

Step:6

 

Step:7- Installation of pgAgent

No-Upgrade mode ( pwd: postgre_manas9)

pwd: Manas147

Step:8

Step:9 : jDBC Setup

Step:10 PostgreSQL 9.3 setup

pwd: postgre_manas9

on a new port

Grand Finish

Step:

community version 9.3

Looks like I was lucky!!

environment  SETTING

Open PostgreSQL db, if it is not open, add few tables (scott_pgsql_employee.txt)

 

Use this script to test emp table.

Step: