Installing PostgreSQL 9.0

offbeatlossData Management

Nov 22, 2012 (4 years and 9 months ago)

256 views

Discovering SQL
all rights reserved (c) 2010 agilitator.com
INSTALLING
PostgreSQL 9.0
all rights reserved (c) 2010 agilitator.com
Download PostgreSQL from the official site:
http://www.postgresql.org/download/windows
Win x86
-
32
Double click on the PostgreSQL
-
9.0.0
-
beta4
-
windows.exe icon
3
all rights reserved (c) 2010 agilitator.com
Click [Yes] button to allow the installation
4
all rights reserved (c) 2010 agilitator.com
5
all rights reserved (c) 2010 agilitator.com
Click [Next] button
6
all rights reserved (c) 2010 agilitator.com
Select installation directory
(or accept the offered default one)
Click [Next] button
7
all rights reserved (c) 2010 agilitator.com
Select installation directory
(or accept the offered default one)
Click [Next] button
Usually, you would want to keep directories where you install software separate from
those designated to store data for performance and security reasons
.
8
all rights reserved (c) 2010 agilitator.com
Select a password for the database supervisor and
service account
Click [Next] button
Password for administrative account is the key to the kingdom. Make it reasonably
secure and safeguard it
.
9
all rights reserved (c) 2010 agilitator.com
Unless you have a valid reason for a change it is
recommended to accept default port
Click [Next] button
Port is a logical concept, a virtual door kept open for the connection from the outside
world. An important point to remember is that it is unique and can be used by only
one application on the computer; otherwise port conflict will prevent software from
functioning properly
10
all rights reserved (c) 2010 agilitator.com
Click [Next] button
Locale support refers to an application respecting cultural preferences regarding
alphabets, sorting, number formatting; default is picked up from your computer
11
all rights reserved (c) 2010 agilitator.com
Click [Next] button
12
all rights reserved (c) 2010 agilitator.com
The installation could take some time depending
on your computer’s hardware
13
all rights reserved (c) 2010 agilitator.com
Click [Finish] button
Stack Builder refers to additional software which could work with your new
PostgreSQL database; included are various connectivity options as well a some
value
-
added applications. To see the full list please visit:
http://pgfoundry.org/projects/stackbuilder
14
all rights reserved (c) 2010 agilitator.com
This screen shows the PostgreSQL database service
running on your Windows machine (the console is
accessible from the Administrative Tools menu).
all rights reserved (c) 2010 agilitator.com
PostgreSQL
PostgreSQL is a full fledged free open source (object)relational
database server which can be used in virtually any environment
without limitations imposed by vendors of commercial software
PostgreSQL is released under the
PostgreSQL License
, a liberal
Open Source license, similar to the
BSD
or
MIT
licenses.
all rights reserved (c) 2010 agilitator.com
Screenshots for this presentation were prepared
by Dzmitry Aliaksandrau, CCNA®