Thursday, April 14, 2011

HOW TO INSTALL POSTGRESQL IN WINDOWS XP

HOW TO INSTALL POSTGRESQL IN WINDOWS XP

Download from :
Click Here to Download



After Download Follow This link:
PostgreSQL Installer Walkthrough



After Installation Follow These Steps:


STEP 1-


C:\Program Files\PostgreSQL\8.2\bin
C:\Program Files\PostgreSQL\8.2\bin>psql -U postgres
Password for user postgres:postgres


Welcome to psql 8.2.3, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

Warning: Console code page (437) differs from Windows code page (1252)
8-bit characters may not work correctly. See psql reference
page "Notes for Windows users" for details.

postgres=#


OR STEP 2- To Set Environment Variables



Click on Start=>Control Panel(Switch to classic user View)=> System
A window will Prompt Then click On " Advanced " button and then select "Environmental Variables"
Set user variables :
Variable name : PATH
Variable Value: C:\Program Files\PostgreSQL\8.2\bin
click on ok and ok and ok .........