Skip to main content

Post 6: iReport: Installation of PostgreSQL



Installation of PostgreSQL

In order to install the PostgreSQL you'll have to download a copy of PostgreSQL installer (http://www.postgresql.org/download/ )  for your operating system.

 

Installing PostgreSQL

PostgreSQL installation is quick and similar to installing any wizard based software installer.
Steps are as following:
1. Double click the postgresql-X.X.X installer.
 
 
2. PostgreSQL installation wizard will start, which will prompt for some installation and information screens.  Continue installaiton by clicking "Next" button.

 
3. Installer will create a database user for you named "postgre" and will prompt you to provide password for your PostgreSQL installation. Provide a password of your choice and press "Next".

 

 

 

 

 

 

Make sure checkbox is unchecked otherwise it unnecessarily redirect to download UI.


Now you are all set to try using your PostgreSQL database installation.

If you are looking for more information on installation guide. Visit PostgreSQL at http://www.enterprisedb.com/learning/pginst_guide.do.

Running PostgreSQL
As you finished installing PostgreSQL, it's database server will start automaticlaly in background.
If not, you may try starting PostgreSQL database server as per following steps:
1. Locate your PostgreSQL installation entry labeled "PostgreSQL9.X" in windows "Start", "Programs" menu.
2. Click on PostgreSQL9.X menu, a submenu will open, click on "Start Server" item and server will start.
This will start the PostgreSQL server in a seprate consol window.

Similraly if you like to stop database server, follow step 2 described above but this time click on "Stop Server" menu item to stop running the server.

PostgreSQL Administration
In order administrate you database installation you will need to run PostgreSQL administration tool.
The pgAdmin allows you to graphically manage and update your database installation by following the steps as follows:
1. Click the pgAdmin item in PostgreSQL menu entry in startup bar of your Windows installation as described in step 1 of "Running PostgreSQL" section.

 


2. A pgAdmin window will open.
 

3. You will see a tree in the "Object Browser" window on the left half of pgAdmin window labelled "Server1".    A node named PostgreSQL9.3 will appear below the Server1. 


4. Double click the PostgreSQL9.3 node and you will see a password prompt. Provide the database password you set in step 3 of "Installing PostgreSQL" section.  (In my case password is root)

 

5. You will see your database instances listed as child of the PostgreSQL9.3 node.
 

 
 
  

 

Comments

Post a Comment

Popular posts from this blog

Index: JSF

Java Server Faces Basics Post 1: JSF : Introduction to JSF  Post 2: JSF:  configuration files  Post 3: JSF: Installation Post 4: JSF: Your first JSF project   Standard JSF Tags Post 1: JSF: textbox example Post 2: JSF: password example Post 3: JSF: textarea example JSF 2 GraphicImage Example Post 4: JSF: GraphicImage Example Post 101 : JSF : The valueChangeListener Attribute Example
Post a Comment
Read more

Index: iReport

iReport for Java ------------------------------------------------------------ Titles and Headers ------------------------------------------------------------ Post 1: iReport : Downloading, installing, and running JasperReports and iReport Post 2: iReport : Creating your first "Hello World" report   Post 3: iReport : Understanding iReport Elements Post 4: iReport : Creating and sizing the title for your report Post 5: iReport: Inserting a company logo in the title of your report  Post 6: iReport : Installation of PostgreSQL Post 7: iReport : Creating a report from relational data Post 8: iReport : Using dynamic titles that can change during report processing. Post 9: iReport : Adding a simple header to your report Post 10: iReport : Setting margins for your report and aligning the report header relative to report margins  ------------------------------------------------------------ Body and Footer ---------------------------------------------------------...
Post a Comment
Read more