|Installing PostgreSQL in windows 7 Professional|
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
|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:7- Installation of pgAgent
No-Upgrade mode ( pwd: postgre_manas9)
|Step:9 : jDBC Setup
|Step:10 PostgreSQL 9.3 setup
on a new port
community version 9.3
Looks like I was lucky!!
|Open PostgreSQL db, if it is not open, add few tables (scott_pgsql_employee.txt)
|Use this script to test emp table.